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
Explain the term 'tables' related to relational database management system?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
Highlight the advantages of PPI(Partition Primary Index).
What is the primary index in teradata?
What are default access rights in teradata?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
what are the uses of fact table and dimension table in banking project?
What is the purpose of joins in teradata and what are the available join types?
What is the use of teradata system software?
What is the basic syntax for teradata select statement?
Differentiate primary key and partition key?
Did you write stored procedures in teradata?
What are the multiload utility limitations?
How do you do backup and recovery in teradata?
If RDBMS is halted what will you do ?