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
- 39271 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / satya
whenever we define a SI an SI subtable is created in each
AMP.For USI they go for a hash distribution, and hence the
actual data row pointed by the USI subtable rows in one AMP
may not be in the same AMP as the subtable..so the AMPs
have to communicate, which is not supported by Multiload.
For NUSI the subtable will store references of only those
actual data rows who exist in the same AMP as the
subtable..they all point to the data in their own
AMP..hence AMPs dont need to communicate here.
Thus the AMPs work in parallal with NUSI and hence Mload
supports that.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is TPD?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
How do you see a ddl for an existing table?
Where is teradata rdbms used?
Explain the parallel data extension in teradata?
What is the purpose of joins in teradata?
During the Display time, how is the sequence generated by Teradata?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
In general, how do you optimze any sql in teradata?
What is inner join and outer join?
What do you mean by teradata intellicloud?
what are the uses of fact table and dimension table in banking project?
What are the various indexes in teradata? How to use them?
