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 is spool space?
What are the different design perspectives used in teradata?
Name the five phases that come under MultiLoad Utility.
What is TPD?
Explain the term 'tables' related to relational database management system?
What is a clique?
Mention a few of the ETL tools that come under Teradata.
Highlight a few of the important components of Teradata?
What tools would you use for that?
What is a node in teradata? Explain
What type of indexing mechanism do we need to use for a typical data warehouse?
What is meant by a Least Cost Plan?
Describe the between keyword in teradata?
Which is faster fastload or multiload?
Explain the term 'primary key' related to relational database management system?