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
- 38493 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 the use of fallback?
What are the available primary index types?
What are the joins in teradata?
What is stored procedure in teradata?
Highlight the need for Performance Tuning.
What are the different methods ot loading a dimension table? A fact table etc?
What is a three-tier data warehouse?
What does Amp contain and what are all the operations that it performs?
What is the use of teradata system software?
What are the joins in teradata and how many types of joins are there in teradata?
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 can be achieved by using the teradata rdbms?
If a Node is busy what are the steps you can take to avoid ?
How does hashing happens in teradata?
Explain vproc in teradata?
