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 are the string manipulation operators and functions associated with teradata?

0 Answers  


A Query was run fine earlier. It is not running properly now. what are proactive steps you can take as a dba ?

1 Answers  


What is called partitioned primary index (ppi)?

0 Answers  


What interface is used to connect to windows based applications?

0 Answers  


Why is the case expression used in teradata?

0 Answers  






What is bteq utility in teradata?

0 Answers  


What is a node in teradata?

0 Answers  


Can some one tell me the ressolution for the error. I was not able to answer this question in wipro interview. "The transaction exceeded the maximum number of rowhash locks allowed"

1 Answers   Wipro,


Explain BYNET.

0 Answers  


What type of indexing mechanism do we need to use for a typical data warehouse?

0 Answers  


What can be achieved by using the teradata rdbms?

0 Answers  


The transaction exceeded the maximum number of rowhash locks allowed

1 Answers   Wipro,


Categories