how to run two workflow(not a sessions) sequentially, what
is the process. Plz explain detailed information.
- 5 Answers
- 19100 Views
- Keane India Ltd, I also Faced
- E-Mail Answers
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 do you join more than 3 flat files in informatica?
write sql query to remove null value following table id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output id name 101 dinesh 102 suresh 103 prakesh
Can you use flat files in Mapplets.
How to recover sessions in concurrent batches?
In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process
without dynamic lookup transformation how to insert new rows and update existing rows?
write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000
Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.
I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?
Differentiate between mapping parameter and mapping variable?
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in
What is the Difference between PowerPlay transformer and power play reports?
Teradata 
