Why FLOAD doesn't supports NUSI? Where as Mload supports
NUSI.
Please explain in this regard.
Thanks in advance.
- 4 Answers
- 12479 Views
- Teradata, I also Faced
- E-Mail Answers
Answer Posted / kishore
FAST LOAD does not support duplicate records...and it does not support SI,JI,RI,HI because these require communication between AMP's....and MLOAD supports NUSI because in NUSI subtable exists in the same amp so it supports.
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What do you mean by teradata intelliflex?
What is the use of fallback?
Where is teradata rdbms used?
What is primary index and secondary index?
What are the different methods ot loading a dimension table? A fact table etc?
What are the 5 phases in a multiload utility?
What are the available primary index types in teradata.
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
Can you fastexport a field, which is primary key by putting equality on that key?
What are the various indexes in teradata? How to use them? Why are they preferred?
Why is the case expression used in teradata?
Explain the most common data types used in teradata?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
What is a sparse index?
