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
- 39267 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / satish
When table is having NUSI, the sub table created by it will
be populated only by Hashing (not like Hash Re distribution
for USI), here redistribution of the records will not be
done,which will take more time generally,
As Fastload and Multiload are intended to Load the data at
fast they have taken out the USI, support so that the target
tables will be loaded very faster,
if we need we can create the SI after loading
---
If you have better ANS please Share with us
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
If RDBMS is halted what will you do ?
What is teradata and why it is used?
What are the various indexes in teradata? How to use them? Why are they preferred?
Explain the advantages of partitioned primary index in a query?
What is meant by a Channel Driver?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
What are the functions of a Parser?
Did you write stored procedures in teradata?
What is inner join and outer join?
Explain teradata architecture in detail with a diagram.
What is the purpose of joins in teradata and what are the available join types?
What is the difference between teradata and oracle?
What is stored procedure in teradata?
How do you define Teradata?
What is primary index and secondary index?
