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


Please Help Members By Posting Answers For Below Questions

What is the purpose of joins in teradata?

546


What does Amp contain and what are all the operations that it performs?

590


What is oltp?

570


What is the basic syntax for teradata select statement?

578


Did you write stored procedures in teradata?

619






If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

1671


What are default access rights in teradata? What explicit right can be given to a user?

653


What is the particular designated level at which a LOCK is liable to be applied in Teradata?

600


Why is the case expression used in teradata?

593


How does hashing happens in teradata?

622


Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

593


What are the different functions performed in development phase?

573


Can you connect multiload from ab initio?

645


Explain teradata utilities?

570


What is meant by a Least Cost Plan?

624