What is the process to restart the multiload if it fails?
Answer Posted / guru
If Mload failed in the Acquisition phase just rerun the
job.If Mload failed in Application Phase:
a) Try to drop error tables, work tables, log tables,
release Mload if required n submit the job
from .Begin Import onwards.
b) if ur table is fallback protected u need to make sure un
fallback and use RELEASE MLOAD IN APPLY sql.
Then resubmit the job.
Guru,
Advanced Teradata Certified Professional
| Is This Answer Correct ? | 37 Yes | 5 No |
Post New Answer View All Answers
What are the functions of a Parser?
When tpump is used instead of multiload?
What are the different table types supported by teradata?
What do you mean by tpt in teradata?
What is multi insert?
What is the meaning of Caching in Teradata?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
Steps to create a data model?
Describe primary index in teradata?
Explain parsing engine in teradata?
Highlight a few of the important components of Teradata?
List out teradata data types?
What are the different table types that are supported by teradata?
Explain the term 'primary key' related to relational database management system?
What are the different functions included in the server software?