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
- 39282 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
What is primary index and secondary index?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
What is the use of fallback?
What is the syntax for case when statement?
How do you set the session mode parameters in bteq?
What are the functions of a teradata dba?
What are the functions of a Parser?
How many tables can you join in v2r5?
How to run a query in teradata?
List out teradata data types?
What is the purpose of joins in teradata?
When tpump is used instead of multiload?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Is multi insert ansi standard?
What does Amp contain and what are all the operations that it performs?
