Why MultiLoad Utility supports only Non Unique Secondary
Index(NUSI) in the Target Table ?
Answer Posted / rajesh kumar s
MulitLoad has support for Non-Unique Secondary Indexes
(NUSIs) since NUSIs are AMP Local. They have subtable within
base table. It has no hash bucket to redirect to another
amp, everything points to their own amp (AMP Local)
If you go with USI, it has hash bucket, which might redirect
to another amp, more possibilites for full table scan.
Motive for avoiding Indexes(other thn NUSI): Avoid Full
table scan.
Regards
Rajesh Kumar S
Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What is meant by a Clique?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What is meant by a node?
Explain vproc in teradata?
What tools would you use for that?
How do you see a ddl for an existing table?
What does Amp contain and what are all the operations that it performs?
List out all forms of LOCKS that are available in Teradata.
What's the difference between timestamp (0) and timestamp (6)?
What is logical data model?
Explain the meaning of Amp?
Explain and compare pros and cons of start schemas?
What are some primary characteristics of teradata?
When tpump is used instead of multiload?
Mention a few of the ETL tools that come under Teradata.