Interested to Buy Any Domain ? << Click Here >> for more details...
Why MultiLoad Utility supports only Non Unique Secondary
Index(NUSI) in the Target Table ?
- 9 Answers
- 38927 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / satya
whenever we define a SI an SI subtable is created in each
AMP.For USI they go for a hash distribution, and hence the
actual data row pointed by the USI subtable rows in one AMP
may not be in the same AMP as the subtable..so the AMPs
have to communicate, which is not supported by Multiload.
For NUSI the subtable will store references of only those
actual data rows who exist in the same AMP as the
subtable..they all point to the data in their own
AMP..hence AMPs dont need to communicate here.
Thus the AMPs work in parallal with NUSI and hence Mload
supports that.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What are the 5 phases in a multiload utility?
Syntax for case when statement?
Can you connect multiload from ab initio?
What is meant by a Channel Driver?
What is primary index and secondary index?
Explain teradata utilities. What is multiload, fast load, tpump?
Why managing the data is important?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
How to Extract data from multiple legacy systems?
What is the purpose of upsert command?
How to identify ppi columns?
In Teradata, what is the significance of UPSERT command?
What are some primary characteristics of teradata?
What is the use of stored procedures in teradata?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
