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
- 38946 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 is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What is the multi-insert?
How is MLOAD Teradata Server restarted after execution?
How many codd's rules are satisfied by teradata database?
How to find duplicates in a table?
Explain teradata utilities?
If a Node is busy what are the steps you can take to avoid ?
What are the different design perspectives used in teradata?
Explain the term 'primary key' related to relational database management system?
How can bottlenecks be identified?
What are the functions of a teradata dba?
What are the functions of a Parser?
If RDBMS is halted what will you do ?
What is the use of virtual processor connectivity in teradata?
What are the newly developed features of Teradata?
