Interested to Buy Any Domain ? << Click Here >> for more details...
What is the process to restart the multiload if it fails?
- 7 Answers
- 54762 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 various etl tools in the market?
What is a dimension table?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
Give a justifiable reason why Multi-load supports NUSI instead of USI.
How would you load a very large file in teradata in general? What utility would you use for it? Why?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
Describe primary index in teradata?
What are the commands to make a new table, change a table and remove a table in teradata?
What are some primary characteristics of teradata?
Different phases of multiload?
What are the different table types supported by teradata?
How would you load a very large file in teradata in general?
Highlight the differences between Primary Key and Primary Index.
Explain the term 'columns' related to relational database management system?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
