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
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 |
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 |
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 |
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 |
Explain load alternative records / rows into multiple targets - informatica
What are the uses of etl tools?
split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar
1 Answers Cap Gemini, TCS, Wipro,
What is complex mapping?
what is data modelling? what are types of modelling?In which suituation will use each one?
where is the reject loader .
How to delete the data in the target table after loaded.
Are there any types of Dynamic Caches in informatica
Is there any model difference between ODS and DWH
disable caching in a lookup transformation?
Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500
what is target load plan