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
Highlight the need for Performance Tuning.
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
In BTEQ, how are the session-mode parameters being set?
What are the primary characteristics of the Teradata.
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
What are the different design perspectives used in teradata?
What is the syntax for case when statement?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Describe the between keyword in teradata?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
Explain the advantages of partitioned primary index in a query?
Explain some differences between mpp and smp?
What is the opening step in basic teradata query script?
What are the various indexes in teradata? How to use them? Why are they preferred?