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
What is logical data model?
What is inner join and outer join?
Explain vproc in teradata?
What are the steps involved in the process flow of the sql statement through channel attached system?
Difference between inner join and outer join?
What are the various indexes in teradata? Why are they preferred?
How many codd's rules are satisfied by teradata database?
How you will check the version of teradata?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What are the functions involved in shared information architecture?
Explain teradata architecture in detail with a diagram.
Why managing the data is important?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
If RDBMS is halted what will you do ?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong