What is the process to restart the multiload if it fails?
Answer Posted / jaya
slight modification in answer 5:
if Mload got failed in Application phase then either you can
restart it by simply resubmitting the job again and it will
be fine and start from the checkpoint, of the last
block that have updated to disk but if you don't want to
restart it then you need to drop the two error tables one
work table one log table and release mload from the target
table.
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
What are the steps involved after the disk manager passes the request?
In the Primary Index, what is the score of AMPs that are actively involved?
What is a three-tier data warehouse?
What are normalization, first normal form, second normal form and third normal form?
What is the maximum number of dml can be coded in a multiload script?
Highlight the advantages of PPI(Partition Primary Index).
Why are oltp database designs not generally a good idea for a data warehouse?
What do high confidence, low confidence and no confidence mean in explain plan?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
What is a sparse index?
What is the use of having index on table?
How to Extract data from multiple legacy systems?
How to select first n records in teradata?
Highlight all the modes that are present under Confidence Level.
Can you connect multiload from ab initio?