Why MultiLoad Utility supports only Non Unique Secondary
Index(NUSI) in the Target Table ?
- 9 Answers
- 36090 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
In Teradata, how do we Generate Sequence?
What are the different functions included in the server software?
What is meant by a Parsing Engine?
Highlight a few of the advantages that ETL tools have over Teradata.
What are different table types used in teradata?
How can we check the version of Teradata that we are using currently?
What is bteq utility in teradata?
Explain the new features of teradata?
Explain the teradata primary index mechanics in detail with a diagram.
What is partitioned primary index (ppi)?
What are the functions performed by bynet?
Describe the set operators in teradata.
What type of indexing mechanism do we need to use for a typical data warehouse?
What is spool space? Why do you get spool space errors?
How to Extract data from multiple legacy systems?
