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
why use references rather than pointers in the public api, particularly for arguments which are modified?
Explain PDE.
What are default access rights in teradata? What explicit right can be given to a user?
what is object level locking ? where do appear this type of locking ?
What are the primary characteristics of the Teradata.
What are the functions involved in shared information architecture?
What are the different table types that are supported by teradata?
Difference between star and snowflake schemas?
How do you determine the number of sessions?
What is the multi-insert?
In the Primary Index, what is the score of AMPs that are actively involved?
What is the use of fallback?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
How to eliminate product joins in a teradata sql query?
What is the use of stored procedures in teradata?