Why MultiLoad Utility supports only Non Unique Secondary
Index(NUSI) in the Target Table ?

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


Please Help Members By Posting Answers For Below Questions

What are the various indexes in teradata? How to use them?

555


If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

1730


What is meant by a dispatcher?

554


Explain the teradata primary index mechanics in detail with a diagram.

559


Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

1689






What is teradata? Also, list out some of the primary characteristics of teradata.

571


What is the command in bteq to check for session settings ?

623


Steps to create a data model?

651


How can bottlenecks be identified?

567


What tools would you use for that?

558


What do you mean by ttu in teradata?

561


What are some primary characteristics of teradata?

539


What is called partitioned primary index (ppi)?

552


Explain some differences between mpp and smp?

582


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 ?

1887