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 exactly do you know about catching in teradata?

0 Answers  


Can u load same data into multiple tables using multiload? How will be the loading process? Whether it will be serially or parallely?

2 Answers   IBM,


how to delete duplicate records in multi set table without using any tables

2 Answers   Accenture, Nest, South Nests Software Solution, Spiro Solutions,


Hi frinds pls help me regarding this question WHY usi is two amp operation in teradata? THANKS IN ADVANCE....

3 Answers  


How to select first n records in teradata?

0 Answers  


What is the use of fallback?

0 Answers  


Can we load a Multi set table using MLOAD?

2 Answers  


which option is used to restart the fastexport script ?

2 Answers   TCS,


Hi frnds...can any one help me regarding this que.. We have column in a table name it as C1 WHICH CONTAIN ALPHANUMERIC AND NUMERIC VALUES. C1 2A 2B 2V 2H 1 2 3 4 5 i want to retrive numeric values like 1,2,3,4,5 How we can get Plz let me know.Thanks in advance

4 Answers   IBM,


What type of indexing mechanism do we need to use for a typical data warehouse?

0 Answers  


What is basic teradata query language?

0 Answers  


What is the default join strategy in Teradata???

5 Answers   IBM,


Categories