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
- 38523 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / tdguy
When it comes to secondary indexes, subtables are build by
TD.
In USI, the subtables are build on all the amps and used,
when this index is used in the query. Since, this involves
communication of amps, mload does not support usi.
In NUSI, the subtables are build within the amps and refer
to the local data of the amp. Thus, NUSI is supported by
mload, since it is amp local.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
How would you load a very large file in teradata in general?
Explain teradata architecture?
What's the difference between timestamp (0) and timestamp (6)?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
How to run a query in teradata?
What is the difference between union and union all in teradata?
Name the five phases that come under MultiLoad Utility.
What are the enhanced features in teradata v2r5 and v2r6?
What are the uses of client software involved in teradata?
Explain amp in teradata?
Explain the parallel data extension in teradata?
What are the available join types in teradata?
What are the available primary index types?
What type of indexing mechanism do we need to use for a typical data warehouse?
