1,If there are 3 workflows are running and if 1st workflow
fails then how could we start 2nd workflow or if 2nd
workflow fails how could we start 3rd workflow?

Answers were Sorted based on User's Feedback



1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workfl..

Answer / james

When 3 workflows are running sequentially,we can definitely
give the dependancy condition by using LINK condition
between the first two workflows as "Failed".
i.e. the second workflow gets started only when first
workflow is failed and same can be applied between second
and third workflows.
Guys any suggestions please let me know.

Thanks,
James.

Is This Answer Correct ?    6 Yes 1 No

1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workfl..

Answer / abhinav prakash

1.We can have a command task at the end of 1st and 2nd workflow.
2.the command task from the first wf will send out a trigger
file for the 2nd workflow.
3.we can use event wait task before the 2nd wf and it ll
wait for the trigger file from the frst wf and once its
available will intiate the 2nd wf.
4.Same logic for the third workflow.

Is This Answer Correct ?    6 Yes 1 No

1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workfl..

Answer / chiranjeevi

We can handle through unix scripts(Job). Using pmcmd
command you can find the status of the first workflow .IF
First wf failed then you can run the second workflow using
pmcmd command.The same thing applicable for 3 wf also.

Please correct me if i am wrong.

Thanks
Chiranjeevi K

Is This Answer Correct ?    2 Yes 0 No

1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workfl..

Answer / dharmendra singh

two ways to do this 1: Use worklet for each workflow and
create and workflow with these worklets and create
dependency. 2: Use a scheduling tools such as control M or
Autosys JIL to create dependency among workflows.

Is This Answer Correct ?    2 Yes 3 No

Post New Answer

More Informatica Interview Questions

I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,


When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?

3 Answers   IBM,


What is a snowflake schema?

0 Answers  


What is the difference between IN and Exists in Oracle?

3 Answers   Deloitte,


what is size of u r database?

0 Answers  






-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

1 Answers   TCS,


How to create the source and target database connections in server manager?

0 Answers   Informatica,


Explain in detail scd type 2 through mapping.

0 Answers  


what is the command to get the list of files in a directory in unix?

5 Answers   iGate,


If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???

5 Answers   Wipro,


i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....

4 Answers   TCS,


i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500

3 Answers   TCS,


Categories