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
Differentiate database data and data warehouse data?
What are the available primary index types in teradata.
Give a justifiable reason why Multi-load supports NUSI instead of USI.
How is MLOAD Teradata Server restarted after execution?
What is a three-tier data warehouse?
What can be achieved by using the teradata rdbms?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
How do you do backup and recovery in teradata?
Highlight the differences between Primary Key and Primary Index.
What are the various etl tools in the market?
In Teradata, how do we Generate Sequence?
Explain fallback 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.
What is TPD?
Difference between inner join and outer join?