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 the command in bteq to check for session settings ?

0 Answers  


How to Skip or Get first and Last Record from Flat File through MultiLoad and TPUMP Utility?

4 Answers   Comsys, IBM,


what is the difference between primary index and secondary index?.

2 Answers   IBM,


What is primary index and secondary index?

0 Answers  


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

0 Answers  


What is the difference between union and union all in teradata?

0 Answers  


"pravalli nagireddy" record is there in address column but i want display only 'nagireddy' from the main string what is query for that pls tell me

9 Answers  


whether Nulls will be counted while doing average? example: we have table column A with following values A -- 5 Null 8 3 Now what is the average of A?

5 Answers   HCL,


List out some of the primary characteristics of teradata.

0 Answers  


Increasing no of amps will increase performance. Is this true?

5 Answers   Infosys,


Explain the types of join supports by teradata?

0 Answers  


In the Primary Index, what is the score of AMPs that are actively involved?

0 Answers  


Categories