Why FLOAD doesn't supports NUSI? Where as Mload supports
NUSI.
Please explain in this regard.
Thanks in advance.
Answer Posted / hari m
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 |
Post New Answer View All Answers
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
How many tables can you join in v2r5?
How do you determine the number of sessions?
What are the different functions included in the server software?
What are the components used in smp and massively parallel processing (mpp) machines?
How do you see a ddl for an existing table?
Explain Teradata performance tuning and optimization?
Can you connect multiload from ab initio?
What is node? How many nodes and amps used in your previous project?
What are differences between teradata and ansi session modes in teradata?
Why does varchar occupy 2 extra bytes?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
What do you mean by fastexport in teradata?
What happens in a conflict? How do you handle that?
How is MLOAD Teradata Server restarted after execution?