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
- 38492 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 some commonly used bteq scripts?
What interface is used to connect to windows based applications?
How do you define Teradata?
What are the functions of a teradata dba?
What are the uses of client software involved in teradata?
What do you mean by ttu in teradata?
How to run a query in teradata?
What is the purpose of upsert command?
What is upsert statement in teradata?
How many codd's rules are satisfied by teradata database?
What are the various reporting tools in the market?
what is sysdba and sysdbc ? which has high priority ?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
How to Extract data from multiple legacy systems?
Highlight the limitations of TPUMP Utility.
