Why MultiLoad Utility supports only Non Unique Secondary
Index(NUSI) in the Target Table ?
- 9 Answers
- 36123 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
How would you load a very large file in teradata in general? What utility would you use for it? Why?
What is the difference between fastload and multiload?
What is teradata? Also, list out some of the primary characteristics of teradata.
What is multi insert?
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 is the purpose of joins in teradata?
What is a clique?
How do you define Teradata?
How can we check the version of Teradata that we are using currently?
What is inner join and outer join?
What is the basic syntax for teradata select statement?
What can be achieved by using the teradata rdbms?
Describe the set operators in teradata.
What is a node in teradata? Explain
What is the use of fallback?
