can we load 10 millions of records into target table by using
tpump?
Answer Posted / 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 View All Answers
how can we analyze the locks ?
What is the difference between teradata and basic rdbms?
How to identify ppi columns?
What is the multi-insert?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
if collect stats but it show low confidence why?
What is the command in bteq to check for session settings ?
What is the purpose of joins in teradata and what are the available join types?
If a Node is busy what are the steps you can take to avoid ?
What is spool space? Why do you get spool space errors?
What is logical data model?
What are the various indexes in teradata? How to use them?
What are the available primary index types?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
What is the difference between global temporary tables and volatile temporary tables?