how to run two workflow(not a sessions) sequentially, what
is the process. Plz explain detailed information.
Answers were Sorted based on User's Feedback
Answer / subash
The best way is obviously to run WF1 and then call WF2
using PMCMD command in the last session of WF1(as a post
session task).If you absolutely want to ensure that the
second wf starts only after graceful completion of wf1 then
simply add a command task for the pmcmd and use the piple
to validate that the previous task is completed properly.
Please let me know if you are not clear or need more info.
Cheers!
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / jayeshmumbai
I would use following methods
1. Create a KSH to call (pmcmd startworkflow) two workflows
one after another (or two statements in ksh). And if
required, I can check successful run of previous workflow
before running another.
2. Make use of command object in second workflow. This
object will be based on ksh which can wait on file created
by successful run of first workflow
3. Make use of even wait task as file watcher and watch a
file created by first workflow.
4. Crude way: Determine workflow execution time. Schedule
two workflows by considering execution time difference.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / don
pimbiliki pilapi
Please let me know if you are not clear or need more info.
Cheers!
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / hardeep
Hi Subash
i didnt understand how to configure 2nd wf to ensure it starts after comp of 1st. pls explain with more detils.
thanks
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / ganesh
as per i know
create a worklet and save the workflow in worklet and run
please let me know is this ans is correct
please call me if this is not an correct 9912063678
| Is This Answer Correct ? | 2 Yes | 9 No |
How many input parameters can exist in an unconnected lookup?
-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?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
what is surrogatekey ? In ur project in which situation u has used ? explain with example ?
what r the transformations that r not involved in mapplet?
what is metadata?
what is the mechanism of the Master-Detail joining condition?
How are parameters defined in informatica?
how we can load rejected record's at run time?(not through bad files)
Briefly define a session task?
Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??
why dimenstion tables are denormalized in nature ?