Why MultiLoad Utility supports only Non Unique Secondary
Index(NUSI) in the Target Table ?
- 9 Answers
- 37305 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 is a three-tier data warehouse?
What is database exceptions in teradata?
What do you mean by caching in teradata?
Explain how spool space is used.
How will you solve the problem that occurs during update?
Highlight all the modes that are present under Confidence Level.
Define views in teradata with general syntax.
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
What type of indexing mechanism do we need to use for a typical data warehouse?
Explain the most common data types used in teradata?
What are the things to be considered while creating secondary index?
What do you mean by fastexport in teradata?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
Why teradata is used?
