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

How is MLOAD Client System restarted after execution?

595


What is dimensional modeling?

589


What are the various indexes in teradata? Why are they preferred?

556


What is upsert statement in teradata?

609


What are aggregate tables? How do you design them using teradata?

634






What is a node in teradata?

579


Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

2900


What is the use of virtual processor connectivity in teradata?

563


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

632


how can we analyze the locks ?

1696


What is logical data model?

636


What are the various reporting tools in the market?

610


Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

587


Explain how spool space is used.

611


How to select first n records in teradata?

605