What is the process to restart the multiload if it fails?
Answer Posted / kumar
Modification to Answer#3 placed above.
Mload fails in application phase: Then e can not access the
table.
1. The solution is we need to restart the mload job or drop
the original table and worktable and logtable and error
tables.
2. If we remove worktables, errortables and logtables then
we can restart the mload job. If we try to restart then it
gives the error messages saying worktable is missing for
the table. Even release mload also doesn't work.
2. If we don't remove: Then if we restart mload job, then
it will be fine and start from the checkpoint, of the last
block that have updated to disk.
Is This Answer Correct ? | 13 Yes | 3 No |
Post New Answer View All Answers
Can you fastexport a field, which is primary key by putting equality on that key?
Explain PDE.
What is the use of virtual processor connectivity in teradata?
What are the steps to create a data model?
Explain the meaning of Amp?
How to load specific no.of records using bteq, or fastload,or multiload
Explain the term 'primary key' related to relational database management system?
How can bottlenecks be identified?
What are the scenarios in which full table scans occurs?
Steps to create a data model?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
What are the advantages of teradata?
What are some primary characteristics of teradata?
What is the purpose of using case expression in teradata?