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 difference between correlated sub queries and inner queries?

4 Answers  


Can you load multiple data files for same target table using fastload?

1 Answers  


Difference between stored procedure and macro?

0 Answers  


Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

0 Answers  


Explain amp in teradata?

0 Answers  


What are the functions involved in shared information architecture?

0 Answers  


What are the types of tables in Teradata

22 Answers   Cap Gemini, Cognizant, Infosys,


What is dimensional modeling?

0 Answers  


How to improve the query performance without taking the collect statistics? In explain plan i have 'NO CONFIDENT'.

2 Answers  


What are the various reporting tools in the market?

0 Answers  


if collect stats but it show low confidence why?

0 Answers   IBM,


How will you solve the problem that occurs during update?

0 Answers  


Categories