If the table does not have duplicates then which utility you
can suggest to load the data ?

Answer Posted / rkraju

Hi,

>>If the table doesn't have any
duplicates(triggers,sp,ji,hi,nusi,usi) we go for fastload.

>>if the table data <1mill we go for bteq

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the functions performed by bynet?

795


What is meant by a Least Cost Plan?

798


How will you solve the problem that occurs during update?

787


What is primary index and secondary index?

778


Can you connect multiload from ab initio?

890


Describe primary index in teradata?

756


What is the use of virtual processor connectivity in teradata?

770


What do you mean by caching in teradata?

809


how do you manage the production space. what are the proactive methods you can take ?

1660


In general, how do you optimze any sql in teradata?

763


What are the different table types supported by teradata?

716


Is multi insert ansi standard?

1936


Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

1705


How you will check the version of teradata?

831


What are the 5 phases in a multiload utility?

802