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 tools would you use for that?
Highlight a few of the advantages that ETL tools have over Teradata.
Explain the teradata primary index mechanics in detail with a diagram.
How many sessions of MAX is PE capable of handling at a particular time?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
how can we analyze the locks ?
What are the frequently used data types in teradata?
What is primary index and secondary index?
In the Primary Index, what is the score of AMPs that are actively involved?
What exactly do you know about catching in teradata?
What is the command in bteq to check for session settings ?
Explain teradata utilities?
Explain parsing engine in teradata?
What is the purpose of joins in teradata and what are the available join types?