Why MultiLoad Utility supports only Non Unique Secondary
Index(NUSI) in the Target Table ?
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
Which is faster fastload or multiload?
What do you mean by parsing?
How many tables can you join in v2r5?
What is the purpose of joins in teradata?
What is the difference between global temporary tables and volatile temporary tables?
What are the different functions included in the server software?
What is collect statistics?
Explain BYNET.
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
What is node? How many nodes and amps used in your previous project?
Explain the teradata primary index mechanics in detail with a diagram.
What is the use of having index on table?
How many sessions of MAX is PE capable of handling at a particular time?
What are teradata utilities?
What are the joins in teradata and how many types of joins are there in teradata?