# | Date | Forum | Type | Thread | Post |
9 | 12 May 2010 @ 05:12 PDT | General | Reply | Need clarification in PI..... | Query + Plan :-
--------------------
Query :-
-----------
USING
_spVV2 (DATE),
_spVV1 (DATE),
_spVV0 (TIMESTAMP(0))INSERT INTO DEL_VOICE_DATA_TEMP SELECT A.DTSTRTCHRG ,A... |
8 | 06 May 2010 @ 09:34 PDT | Analytics | Reply | Calendar table calculation | how come you are here... |
7 | 05 May 2010 @ 01:47 PDT | Tools | Reply | Delete using Mload | Hi 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
(
... |
6 | 20 Apr 2010 @ 02:33 PDT | General | Reply | Need 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... |
5 | 20 Apr 2010 @ 02:19 PDT | Tools | Reply | Delete using Mload | No stats on the partition column..
will it affect.... |
4 | 19 Apr 2010 @ 03:23 PDT | Database | Reply | Junk 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... |
3 | 19 Apr 2010 @ 02:06 PDT | UDA | Reply | Numeric Overflow error | No you wont get the result with distinct.
Better you cast the column which you are going to sum.this will definitely solve your problem. |
2 | 19 Apr 2010 @ 01:07 PDT | General | Topic | Need 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... |
1 | 17 Apr 2010 @ 05:25 PDT | Tools | Topic | Delete using Mload | Hi,
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... |
|
|