Interested to Buy Any Domain ? << Click Here >> for more details...
What is the process to restart the multiload if it fails?
- 7 Answers
- 54409 Views
- I also Faced
- E-Mail Answers
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
what are the day to day activities of teradata DBA ?
Explain the term 'database' related to relational database management system?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
What does sleep function does in fast load?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What is meant by a node?
What are the various etl tools in the market?
What are the components used in smp and massively parallel processing (mpp) machines?
Highlight all the modes that are present under Confidence Level.
What is dimensional modeling?
What are the updated features of teradata?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
What is meant by a dispatcher?
What are the various indexes in teradata?
Why does varchar occupy 2 extra bytes?
