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 |
we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?
how to load rows into fact table in data warehouse
where to store informatica rejected data? How to extract the informatica rejected data?
WE HAVE 10 RECORDS IN SOURCE IN THAT GOOD RECORDS GO TO RELATIONAL TARGET AND BAD RECORDS GO TO TARGET FLAT FILE ? HERE IF ANY BAD RECORDS MEANS ITS LOAD INTO FLAT FILE AND SEND AN EMAIL , IF NO BAD RECORDS MEANS NO NEED TO SEND EMAIL . PLZ HELP ME ...
MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION
Why sorter is an active transformation?
Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?
in realtime which situations u can use unconnected lookup transformation
In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?
While importing the relational source defintion from database,what are the meta data of source U import?
From where you extract the data, how you did it into informatica? explain....
1 Answers Accenture, Unisoft Infotech,
how many types transformations supported by sortedinput?