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

How teradata makes sure that there are no duplicate rows being inserted when its a set table?

551


Give a justifiable reason why Multi-load supports NUSI instead of USI.

669


What is the use of stored procedures in teradata?

560


What is smp and mpp platforms?

524


Highlight the advantages of PPI(Partition Primary Index).

559






Why managing the data is important?

583


What are the scenarios in which full table scans occurs?

530


Explain the teradata primary index mechanics in detail with a diagram.

561


What is difference between user and database in teradata?

611


why use references rather than pointers in the public api, particularly for arguments which are modified?

548


Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

564


What is the primary index in teradata?

582


What is meant by a Channel Driver?

640


What are differences between teradata and ansi session modes in teradata?

617


In Teradata, what is the significance of UPSERT command?

587