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
- 38888 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 many sessions of MAX is PE capable of handling at a particular time?
What do you mean by ttu in teradata?
What is teradata and why it is used?
Highlight the need for Performance Tuning.
How to run a query in teradata?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
What are the various indexes in teradata?
How do you do backup and recovery in teradata?
List out teradata data types?
What are the multiload utility limitations?
What are the different design perspectives used in teradata?
Explain the advantages of partitioned primary index in a query?
Explain teradata utilities. What is multiload, fast load, tpump?
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 is the purpose of using case expression in teradata?
