Why MultiLoad Utility supports only Non Unique Secondary
Index(NUSI) in the Target Table ?
- 9 Answers
- 36124 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / madhu
Like FastLoad, MultiLoad does not support Unique Secondary
Indexes (USIs). But unlike FastLoad, it does support the
use of Non-Unique Secondary Indexes (NUSIs) because the
index subtable row is on the same AMP as the data row.
MultiLoad uses every AMP independently and in parallel. If
two AMPs must communicate, they are not independent.
Therefore, a NUSI (same AMP) is fine, but a USI (different
AMP) is not.
| Is This Answer Correct ? | 29 Yes | 6 No |
Post New Answer View All Answers
Name the five phases that come under MultiLoad Utility.
What is collect statistics?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What is smp and mpp platforms?
What are the joins in teradata?
How many types of joins are there in teradata?
What are the 5 phases in a multiload utility?
Explain fastload in teradata?
What does sleep function does in fast load?
Steps to create a data model?
What are the functions of a Parser?
What is bteq script in teradata?
What do you mean by teradata sql assistant?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
How can bottlenecks be identified?
