Why MultiLoad Utility supports only Non Unique Secondary
Index(NUSI) in the Target Table ?
Answer Posted / priya
Fload It self will not support Secondarys Indexs concept
becuase Fload stands for Fast load so.. it will not proceed
futhur in case the table is defined with Secondary indexes
we need to drop the Secondary index in case if we need to
proceed furthur.
So where is the concpets USI and Non-Unique secondaey
indexes in Fload.
Regards,
Priya K
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is meant by a Clique?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
What are the different table types that are supported by teradata?
Explain the parallel data extension in teradata?
Highlight the limitations of TPUMP Utility.
What is a clique?
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 ?
What is TPD?
Where is teradata rdbms used?
What are the various indexes in teradata? How to use them?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
Syntax for case when statement?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
What is the command in bteq to check for session settings ?
What is a node in teradata? Explain