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 is the maximum number of dml can be coded in a multiload script?
What is spool space? Why do you get spool space errors?
While creating table my dba has fallback or no fallback in his ddl. What is that?
What are the advantages of teradata?
What is bteq script in teradata?
How do you design aggregate tables using teradata?
I Have Name field in a Table Name ------------- abcde;fgh;ijk; abc;def;jklm;no I want to write a sql to display name field data with out ';'.so i want to replace ; with '' how will write in Teradata
what are the file sizes in your project?
what is DYNAMIC SQL in TD?
The transaction exceeded the maximum number of rowhash locks allowed
What are the steps to create a data model?
There is a load to the Table every one hour and 24/7.Morning trafic is high, afternoon trafiic is less, Night trafiic is high.According to this situation which Utility you use and how do you load,which utility used?