Why MultiLoad Utility supports only Non Unique Secondary
Index(NUSI) in the Target Table ?
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
What is the purpose of using case expression in teradata?
Explain and compare pros and cons of start schemas?
any one answer me how they can analyzing the project using data ware housing?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
Highlight the limitations of TPUMP Utility.
What is meant by a dispatcher?
Explain the term 'database' related to relational database management system?
Write a program to show the parser component used in teradata?
What is the meaning of Caching in Teradata?
What are the joins in teradata?
What do you mean by teradata sql assistant?
List out all forms of LOCKS that are available in Teradata.
What do you mean by teradata intelliflex?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?