Why FLOAD doesn't supports NUSI? Where as Mload supports
NUSI.
Please explain in this regard.
Thanks in advance.
- 4 Answers
- 13263 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
any one answer me how they can analyzing the project using data ware housing?
Explain PDE.
In the Primary Index, what is the score of AMPs that are actively involved?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
What are the uses of bynets in multi-node systems?
Explain amp in teradata?
Difference between inner join and outer join?
Highlight a few of the important components of Teradata?
Describe primary index in teradata. And what are the available primary index types?
What do you mean by tpt in teradata?
What are aggregate tables? How do you design them using teradata?
How to load specific no.of records using bteq, or fastload,or multiload
How can bottlenecks be identified?
What is the function of parser component in teradata?
What is teradata? What are some primary characteristics of teradata?
