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
- 38502 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
In BTEQ, how are the session-mode parameters being set?
What are the enhanced features in teradata v2r5 and v2r6?
Can you connect multiload from ab initio?
What are the joins in teradata?
Highlight the points of differences between the database and user in Teradata.
Highlight all the modes that are present under Confidence Level.
Explain fastload in teradata?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
What are the functions performed by bynet?
What is spool space?
What are the functions of a teradata dba?
Explain the term 'foreign key' related to relational database management system?
how can we analyze the locks ?
What is the use of virtual processor connectivity in teradata?
