I have 5 sessions s1,s2,s3,s4 & s5 and i want execute
s1,s2,s3,s5 after s4. How?

Answer Posted / prasad

Create s1,s2,s3,s5 in a worklet and call this worklet in
the workflow,create s5 in the wokflow and link it after the
worklet is completed or succedded s4 should start.

Check the link condition between worklet and s4 session in
should be suceeded

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is stop and abort are same in informatica?

730


Different qualification between a related rotate toward the sky and isolates look upward?

739


which one is better performance wise joiner or look up

808


Explain the informatica workflow?

792


Is it possible to revert a global repository to local one and why?

821






r u done any partitions in ur project?

1546


Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

990


What is exclusive and normal mode for repository services?

862


What are the designer tools for creating transformations?

861


CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

8323


What is a sorter transformation?

855


What are the steps involved in the migration from older version to newer version of Informatica Server?

1789


Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

1815


How to do unit testing in informatica? How to load data in informatica ?

850


lookup transformation with screenshots

3746