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


Please Help Members By Posting Answers For Below Questions

What tools would you use for that?

565


Highlight a few of the advantages that ETL tools have over Teradata.

609


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

565


How many sessions of MAX is PE capable of handling at a particular time?

589


How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1278






Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

566


how can we analyze the locks ?

1696


What are the frequently used data types in teradata?

598


What is primary index and secondary index?

568


In the Primary Index, what is the score of AMPs that are actively involved?

574


What exactly do you know about catching in teradata?

635


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

634


Explain teradata utilities?

563


Explain parsing engine in teradata?

589


What is the purpose of joins in teradata and what are the available join types?

541