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

Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

656


Highlight the need for Performance Tuning.

595


Did you write stored procedures in teradata?

623


What is the difference between teradata and basic rdbms?

570


Why does varchar occupy 2 extra bytes?

617






What is a node in teradata?

589


Explain how spool space is used.

623


How to eliminate product joins in a teradata sql query?

608


Why managing the data is important?

598


What do you mean by fastexport in teradata?

565


What is the opening step in basic teradata query script?

600


What is the purpose of indexes?

602


Explain teradata utilities. What is multiload, fast load, tpump?

579


What is meant by a dispatcher?

572


What are the design features involved in teradata?

553