top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How to run two workflow (not a sessions) sequentially in Informatica, what is the process?

+1 vote
1,332 views
How to run two workflow (not a sessions) sequentially in Informatica, what is the process?
posted Jul 31, 2015 by Amit Sharma

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

1 Answer

+1 vote

1st Option:

WF1 --> S1 --> ER

ER is a Event Raise Task, in this task you would write a simple shell command to create zero byte file via touch command after successful execution of S1.

WF2 --> EW --> S2

EW is a Event Wait Task, in this task you would place that file.

So, as soon as the 1st WF is executed successfully ER would create a zero byte file and hence that file would be available at EW and your second, i.e. WF2 will start after WF1....

Hope it helps u, vote if the ans is useful to you. there are also other options but this is much practiced.

Arif

answer Jul 31, 2015 by Arif Shaikh
Similar Questions
+3 votes

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?

+1 vote

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?

+2 votes

I have a job scheduled by tivoli for an Informatica workflow. I have checked property to save workflow logs for 5 runs.

Job is running fine through informatica but if u try to run is from tivoli using pmcmd it fails to rename the workflow log file .

Please help, I am getting this error :

Cannot rename workflow log file [E:\Informatica\etl_d\WorkflowLogs\wf_T.log.bin] to [E:\Informatica\etl_d\WorkflowLogs\wf_T.log.4.bin]. Please check the Integration Service log for more information. Disconnecting from Integration Service

0 votes

In a mapping we use delimited flat file having 3 columns.The column separated through comma. But i have a requirement that in between the column there is a column having 2 comma.So how should I process the column in the mapping?

...