Why MultiLoad Utility supports only Non Unique Secondary
Index(NUSI) in the Target Table ?
- 9 Answers
- 36121 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 are the enhanced features in teradata v2r5 and v2r6?
How many tables can you join in v2r5?
Explain teradata architecture in detail with a diagram.
How do you create tables? Exact syntax, and create profiles, users in teradata?
Why do you get spool space errors? How do trouble-shoot them?
Explain teradata architecture?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What is node? How many nodes and amps used in your previous project?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
Highlight all the modes that are present under Confidence Level.
What is meant by a Highest Cost Plan?
What do you mean by parsing?
What are differences between teradata and ansi session modes in teradata?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
What happens in a conflict? How do you handle that?
