Recovery Strategies in Informatica


While executing a workflow we may be happy if runs successfully without any of its sessions or any tasks failing. There are cases where the sessions get fail due to fatal error which happens due to problem in creating logs by Integration service.
The entire effort goes waste if the target tables are used in more than one workflow.The worst case may be arise tables needed to truncated again since there may be weekly,biweekly or monthly run which mostly occurs based on how the reports are used by senior management.
To avoid this painful thing from happening Informatica has provided lot of options that can be used according to different scenarios.

Workflow Level:
In workflow properties set Enable HA recovery and don’t forget to set the number of times the session should be restarted before a workflow gets failed.
The above mentioned option will help in case of session failure due to connection interruption or fatal errors.

Session Level:
Select any of the three options such as
1.Restart task
2.Fail task and continue workflow.

In case of the dependencies on targets set options like faiure parent if child fails.

About sudhans

Quizzy mind

Posted on January 29, 2011, in Informatica. Bookmark the permalink. 2 Comments.

  1. Does Informatica Cache the entire data (all columns) and keep or it only caches the PK Columns?

Leave a comment