can we load 10 millions of records into target table by using
tpump?



can we load 10 millions of records into target table by using tpump?..

Answer / rkraju

yes we can load 10 millions of records into target table by
using tpump but it takes more time.y because it applies
rowhash lock on each row.,
>>generally less volume of data we go for tpump.,
>>if the table doen't have any limitations of fastload d
multiload then go for fastload.,

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More Teradata Interview Questions

What is the maximum number of dml can be coded in a multiload script?

0 Answers  


What is spool space? Why do you get spool space errors?

0 Answers  


While creating table my dba has fallback or no fallback in his ddl. What is that?

0 Answers  


What are the advantages of teradata?

0 Answers  


What is bteq script in teradata?

0 Answers  






How do you design aggregate tables using teradata?

1 Answers  


I Have Name field in a Table Name ------------- abcde;fgh;ijk; abc;def;jklm;no I want to write a sql to display name field data with out ';'.so i want to replace ; with '' how will write in Teradata

3 Answers   Wipro,


what are the file sizes in your project?

2 Answers  


what is DYNAMIC SQL in TD?

1 Answers   IBM,


The transaction exceeded the maximum number of rowhash locks allowed

1 Answers   Wipro,


What are the steps to create a data model?

0 Answers  


There is a load to the Table every one hour and 24/7.Morning trafic is high, afternoon trafiic is less, Night trafiic is high.According to this situation which Utility you use and how do you load,which utility used?

4 Answers   IBM,


Categories