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
- 38664 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 are types of partition primary index (ppi) in 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?
What do you mean by teradata intellicloud?
Difference between stored procedure and macro?
Describe the between keyword in teradata?
Highlight all the modes that are present under Confidence Level.
Why is the case expression used in teradata?
What is a level of granularity of a fact table?
What are some commonly used bteq scripts?
Differentiate database data and data warehouse data?
How many types of joins are there in teradata?
Explain teradata architecture?
What are the updated features of teradata?
why use references rather than pointers in the public api, particularly for arguments which are modified?
What type of indexing mechanism do we need to use for a typical data warehouse?
