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

Answers were Sorted based on User's Feedback



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

Answer / 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

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

Answer / tdguy

If the table is empty and the amount of data to be loaded
is in millions, then, fload would be a better option.

Is This Answer Correct ?    4 Yes 0 No

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

Answer / mallikahrjunarao rayidi

Fastload is better for unique rows loading

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Teradata Interview Questions

What is meant by a Parsing Engine?

0 Answers  


Can we collect statistics on multiple columns?

0 Answers  


what is the difference between filter and router transmissions

2 Answers  


what is the difference between bpo and call centre?

2 Answers   American Solutions,


1)WHAT IS THE EXACT DIFFERENCE BETWEEN TERADATA AND ORACLE? 2)MOST OF THE COMPANIES ARE USING TARA DATA FOR "DWH PROJECTS" ONLY? WHY?

6 Answers   Bank Of America, Wipro,






What is the function of parser component in teradata?

0 Answers  


How many types of index are present in teradata?

1 Answers  


which option is used to restart the fast load script?

2 Answers  


What is Difference b/w PI & PPI?how to implement PPI?

3 Answers   Wipro,


how do you handle ET and UV errors ?

2 Answers  


How do you design aggregate tables using teradata?

1 Answers  


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

0 Answers  


Categories