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!

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.

Answer / don

pimbiliki pilapi

Please let me know if you are not clear or need more info.
Cheers!

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

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

what is scd?

6 Answers  

How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this

9 Answers   Deloitte,

why we r using presql&postsql in source qualifier?

1 Answers   HP,

What are parallel querys and query hints?

1 Answers  

Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.

7 Answers   TCS,

what is the command to get the list of files in a directory in unix?

5 Answers   iGate,

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

0 Answers  

how can we check whether a particular cache is static or dynamic?

1 Answers   InfoCepts, TCS,

Explain pmcmd command usage in informatica

0 Answers   Informatica,

how much memory (size) occupied by a session at runtime

4 Answers   Wipro,

Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep

3 Answers   CSC, iNautix,

what is normalization? explain 1st NF, 2nd NF, 3rd NF

1 Answers   SunGard,