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
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
What is a dimension table?
Highlight a few of the important components of Teradata?
Explain and compare pros and cons of snow flake schemas?
What is multi insert?
how can we analyze the locks ?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
Describe primary index in teradata. And what are the available primary index types?
Highlight the need for Performance Tuning.
What are aggregate tables? How do you design them using teradata?
What are the functions of a teradata dba?
What are the different table types that are supported by teradata?
What are the uses of client software involved in teradata?
What is the command in bteq to check for session settings ?
Highlight a few of the advantages that ETL tools have over Teradata.