Why MultiLoad Utility supports only Non Unique Secondary
Index(NUSI) in the Target Table ?
- 9 Answers
- 36035 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
Can we collect statistics on multiple columns?
Define views in teradata with general syntax.
what are the day to day activities of teradata DBA ?
Explain fastload in teradata?
What are the various indexes in teradata? Why are they preferred?
Which is faster fastload or multiload?
What is the purpose of upsert command?
How do you see a ddl for an existing table?
Difference between stored procedure and macro?
Difference between multiload and tpump?
What is teradata?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
Mention a few of the ETL tools that come under Teradata.
What is the multi-insert?
What is oltp?
