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
- 39270 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
How to identify ppi columns?
Difference between star and snowflake schemas?
What is a level of granularity of a fact table?
What are the newly developed features of Teradata?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
What is smp and mpp platforms?
What is meant by a Parsing Engine?
What is meant by a Channel Driver?
Explain vproc in teradata?
What are the various reporting tools in the market?
How is the teradata different from oracle?
What is teradata?
Mention a few of the ETL tools that come under Teradata.
What is meant by a Highest Cost Plan?
What tools would you use for that?
