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

suppose one Cylinder split data blocks are moved from where?

1 Answers  


Highlight the differences between Primary Key and Primary Index.

0 Answers  


what is the advantages of other etl tool than teradata utilities or vice versa ?(datastage/informatica)

4 Answers  


if collect stats but it show low confidence why?

0 Answers   IBM,


What are the various indexes in teradata? How to use them? Why are they preferred?

0 Answers  






Diff b/w v2r5 and v2r6 ?

3 Answers   TCS,


Explain the types of join supports by teradata?

0 Answers  


Explain the term 'database' related to relational database management system?

0 Answers  


How to run a query in teradata?

0 Answers  


what are the default access rights in the teradata?

1 Answers  


Hi All, can anyone tell me how many types of Skew exists? whats the difference between amp skew,data skew,cpu skew, io skew, delta amp cpu ?

2 Answers  


Write a single SQL to delete duplicate records from the a single table based on a column value. I need only Unique records at the end of the Query.

13 Answers  


Categories