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
Describe primary index in teradata?
What are default access rights in teradata?
What is spool space? Why do you get spool space errors?
What is spool space?
why use references rather than pointers in the public api, particularly for arguments which are modified?
What are the steps involved after the disk manager passes the request?
What is meant by a Virtual Disk?
Why does varchar occupy 2 extra bytes?
Can you connect multiload from ab initio?
Can we collect statistics on multiple columns?
Difference between multiload and tpump?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
How do you do backup and recovery in teradata?
Why are oltp database designs not generally a good idea for a data warehouse?
What are the available primary index types?