Interested to Buy Any Domain ? << Click Here >> for more details...
What is the process to restart the multiload if it fails?
- 7 Answers
- 54990 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 is meant by a Clique?
In Teradata, how do we Generate Sequence?
What is the primary index in teradata?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
Different phases of multiload?
What is the basic syntax for teradata select statement?
What are the steps involved after the disk manager passes the request?
What is meant by a Highest Cost Plan?
What is meant by Teradata Gateway?
Differentiate database data and data warehouse data?
Describe primary index in teradata. And what are the available primary index types?
Explain the term 'columns' related to relational database management system?
What are the various indexes in teradata? How to use them?
Why do you get spool space errors? How do trouble-shoot them?
What are the updated features of teradata?
