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
- 38945 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
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
How to find duplicates in a table?
What is the meaning of Caching in Teradata?
Difference between star and snowflake schemas?
Explain teradata utilities?
Highlight all the modes that are present under Confidence Level.
Explain teradata vs. Redshift?
What are the steps to create a data model?
Highlight a few of the advantages that ETL tools have over Teradata.
What is the command in bteq to check for session settings ?
Explain the term 'columns' related to relational database management system?
What are the uses of bynets in multi-node systems?
What type of indexing mechanism do we need to use for a typical data warehouse?
What are default access rights in teradata?
Highlight a few of the important components of Teradata?
