#DateForumTypeThreadPost
912 May 2010 @ 05:12 PDTGeneralReplyNeed clarification in PI.....Query + Plan :- -------------------- Query :- ----------- USING _spVV2 (DATE), _spVV1 (DATE), _spVV0 (TIMESTAMP(0))INSERT INTO DEL_VOICE_DATA_TEMP SELECT A.DTSTRTCHRG ,A...
806 May 2010 @ 09:34 PDTAnalyticsReplyCalendar table calculationhow come you are here...
705 May 2010 @ 01:47 PDTToolsReplyDelete using MloadHi Dieter, Please see the below table defn: CREATE MULTISET TABLE SA_TEST.VOICE_CDR_DATA ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT ( ...
620 Apr 2010 @ 02:33 PDTGeneralReplyNeed clarification in PI.....David :: Actually this left outer join i am doing for the duplicate check. As mentioned above PI_COLUMN is the combination of 10 columns.... So if i am using left outer join and insert in to a t...
520 Apr 2010 @ 02:19 PDTToolsReplyDelete using MloadNo stats on the partition column.. will it affect....
419 Apr 2010 @ 03:23 PDTDatabaseReplyJunk Characters in FASTEXPORTED Flat file..Suma,lavakumar, Jimm is absolutely right, casting the complete result to char(length) will not give any junk character. Sima >Spaces will be based on the record length, If you know the maximu...
319 Apr 2010 @ 02:06 PDTUDAReplyNumeric Overflow errorNo you wont get the result with distinct. Better you cast the column which you are going to sum.this will definitely solve your problem.
219 Apr 2010 @ 01:07 PDTGeneralTopicNeed clarification in PI.....I am having a landing table and a target table with primary index on same column at landing table and target table. When I am loading target table from landing table with Stored Procedure with lef...
117 Apr 2010 @ 05:25 PDTToolsTopicDelete using MloadHi, I am using mload to delete the data from a 10 TB table. The table is partitioned based on date. The table is having NUSI on two columns. When we dropped the 20 partition without drop th...