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
- 38859 Views
- IBM, I also Faced
- E-Mail Answers
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 are aggregate tables? How do you design them using teradata?
What are the string manipulation operators and functions associated with teradata?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
How to identify ppi columns?
Can we collect statistics on table level?
Can you connect multiload from ab initio?
In the Primary Index, what is the score of AMPs that are actively involved?
How to eliminate product joins in a teradata sql query?
what are the day to day activities of teradata DBA ?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
What are the different design perspectives used in teradata?
In Teradata, what is the significance of UPSERT command?
How do you do backup and recovery in teradata?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
Different phases of multiload?
