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
- 38926 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
Give a justifiable reason why Multi-load supports NUSI instead of USI.
What are the joins in teradata and how many types of joins are there in teradata?
What is the difference between union and union all in teradata?
Can you connect multiload from ab initio?
Explain teradata vs. Redshift?
What is meant by a Channel Driver?
What are the uses of client software involved in teradata?
What are the main components of teradata system?
While creating table my dba has fallback or no fallback in his ddl. What is that?
Explain teradata utilities. What is multiload, fast load, tpump?
What are the primary characteristics of the Teradata.
how can we analyze the locks ?
Highlight a few of the important components of Teradata?
Difference between inner join and outer join?
What is collect statistics?
