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 |
What is polling?
Describe data concatenation?
Write the unconnected lookup syntax?
what are the reusable tasks in informatica ?
11 Answers CTS, HP, IBM, TCS,
What is meta data and system catalog?
Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance
I want expect first and last record remaining all records will be loaded into target? which transformations we can use?
source target Q410 4 2010 Q311 3 2011 Q412 4 2012 Q309 3 2009
how to run the batch using pmcmd command
How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
can a port in expression transf be given the name DISTINCT