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
Why does varchar occupy 2 extra bytes?
What is oltp?
What are the different table types supported by teradata?
What are the available primary index types in teradata.
What is spool space? Why do you get spool space errors?
Explain how spool space is used.
What do high confidence, low confidence and no confidence mean in explain plan?
Is multi insert ansi standard?
What are the various indexes in teradata? How to use them? Why are they preferred?
What is the purpose of joins in teradata and what are the available join types?
What is meant by a Channel Driver?
Highlight a few of the advantages that ETL tools have over Teradata.
What is bteq script in teradata?
How do you see a ddl for an existing table?
Which is more efficient group by or distinct to find duplicates?