- Setup a email notification for an ETL job. You will receive an email when the job is failed/successfully completed.
- If the job is failed, login to DAC and identify which task has failed.
- Login to Informatica workflow monitor and retrieve the failed tasks log and identify the cause of the failed task.
- Rectify the issue and restart the load plan.