Why MultiLoad Utility supports only Non Unique Secondary
Index(NUSI) in the Target Table ?
- 9 Answers
- 37310 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
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
List out all forms of LOCKS that are available in Teradata.
Name the five phases that come under MultiLoad Utility.
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
What is inner join and outer join?
What is the purpose of upsert command?
Why does varchar occupy 2 extra bytes?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
Explain the parallel data extension in teradata?
How to view every column and the columns contained in indexes in teradata?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
What is a node in teradata?
What are the string manipulation operators and functions associated with teradata?
