Why MultiLoad Utility supports only Non Unique Secondary
Index(NUSI) in the Target Table ?
- 9 Answers
- 36099 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / hari m
WHAT EVER WE DISCUSSED ABOVE IS OK WITH THE MLOAD.
EVEN I AGREE WITH MLOAD, FLOAD HAS LIMITIATON AS USI, JI,
TRIGGERS MULITIPLE AMP OPERATIONS.
I have a quick question why FLOAD doesn't supports NUSI? As
posted above if Nusi is operations are within in same amp.
Please explain in this regard.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What do you mean by teradata sql assistant?
What are the different functions performed in development phase?
how many modules are there in telecome domain?how to explain the architecture?
Explain the term 'primary key' related to relational database management system?
What is multi insert?
What is meant by a Channel Driver?
What are the different functions included in the server software?
Explain the teradata primary index mechanics in detail with a diagram.
What is called partitioned primary index (ppi)?
Which is faster fastload or multiload?
Highlight the advantages of PPI(Partition Primary Index).
Can we collect statistics on multiple columns?
How do you set the session mode parameters in bteq?
What are the things to be considered while creating secondary index?
How to load specific no.of records using bteq, or fastload,or multiload
