can we load 10 millions of records into target table by using
tpump?
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 |
What are aggregate tables? How do you design them using teradata?
What is the use of upsert command in teradata?
What is bteq utility in teradata?
What do you mean by tpt in teradata?
Did you write stored procedures in teradata?
How do you check the performance of Teradata Query and list down the basic Performance Tuning steps you use?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What is Join Index in TD and How it works?
What is the difference between fastload and multiload? Which one is faster?
List the logical and conditional operators that are used with teradata along with their meanings?
Diff b/w v2r5 and v2r6 ?
Give a justifiable reason why Multi-load supports NUSI instead of USI.