hari maanchaala


{ City } hyd
< Country > india
* Profession * it professional
User No # 89440
Total Questions Posted # 2
Total Answers Posted # 3

Total Answers Posted for My Questions # 10
Total Views for My Questions # 22941

Users Marked my Answers as Correct # 2
Users Marked my Answers as Wrong # 0
Questions / { hari maanchaala }
Questions Answers Category Views Company eMail

Why FLOAD doesn't supports NUSI? Where as Mload supports NUSI. Please explain in this regard. Thanks in advance.

Teradata,

4 Teradata 12403

Hi Friends I have a sql question, We have the source data as below. 101 address1, address2, address3 and the output shoulb like below 101 address1 101 address2 101 address3 Required a SQL query for this output. Please let me know if you have any sql query for this. Thanks in advance. Hari M

JPMorgan Chase,

6 Teradata 10538




Answers / { hari maanchaala }

Question { IBM, 35965 }

Why MultiLoad Utility supports only Non Unique Secondary
Index(NUSI) in the Target Table ?


Answer

WHAT EVER WE DISCUSSED ABOVE IS OK WITH THE MLOAD.

EVEN I AGREE WITH MLOAD, FLOAD HAS LIMITIATON AS USI, JI,
TRIGGERS MULITIPLE AMP OPERATIONS.


I have a quick question why FLOAD doesn't supports NUSI? As
posted above if Nusi is operations are within in same amp.

Please explain in this regard.

Is This Answer Correct ?    0 Yes 0 No

Question { Teradata, 12403 }

Why FLOAD doesn't supports NUSI? Where as Mload supports
NUSI.

Please explain in this regard.

Thanks in advance.


Answer

quoted points absolutely correct. i.e,
FAST LOAD does not support duplicate records...and it does
not support SI,JI,RI,HI because these require communication
between AMP's

I feel the posted ans is still not appropriate!

NUSI concept is same for even fload, as stated above in
NUSI subtable exists in the same amp so mload supports.
then why fload does not supports??

Now I guess my question more clear!!

Is This Answer Correct ?    2 Yes 0 No


Question { JPMorgan Chase, 10538 }

Hi Friends

I have a sql question, We have the source data as below.

101 address1, address2, address3

and the output shoulb like below

101 address1
101 address2
101 address3

Required a SQL query for this output.

Please let me know if you have any sql query for this.

Thanks in advance.

Hari M


Answer

Hi Vennala

The posted query will work fine. But what if incase 'N'
no.of columns, like address1, address2..., address n.

The query will become lenghty with N no.of Unions.

Is there any script or procedure as alternative??

Please help me out in this regard.

Thanks,
Hari

Is This Answer Correct ?    0 Yes 0 No