top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How to run only failed sessions in a workflow [CLOSED]

+3 votes
253 views

In a workflow there are sessions connected in parallel and in sequence. Suppose some sessions which are in parallel and in sequential mode are failed, How do I restart the workflow with only failed sessions. How can I design this in Informatica?

This question has an answer at: How to run only failed sessions in a workflow
posted Apr 3, 2014 by Rohini Agarwal

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

A large publishing client asked us to implement something similar to what you asked. We crated a database table to keep track of successful sessions within a workflow. Each session will have a mapping at the end that adds an entry to database which says I passed or failed. When we try to run in a recovery mode we query the database at the beginning of each session to find out if we need to run this session or not.

We also provided a web interface to this table where business users can manually choose which session to run or escape based on their needs.

answer Apr 4, 2014 by Shweta Singh
...