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
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
What is teradata? Also, list out some of the primary characteristics of teradata.
What are the functions involved in shared information architecture?
how many modules are there in telecome domain?how to explain the architecture?
What is bteq utility in teradata?
What is called partitioned primary index (ppi)?
Is multi insert ansi standard?
Can you fastexport a field, which is primary key by putting equality on that key?
During the Display time, how is the sequence generated by Teradata?
How is the teradata different from oracle?
What is a sparse index?
What are some commonly used bteq scripts?
What is the difference between teradata and oracle?
What is meant by a Parsing Engine?
What are differences between teradata and ansi session modes in teradata?