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
Is stop and abort are same in informatica?
Different qualification between a related rotate toward the sky and isolates look upward?
which one is better performance wise joiner or look up
Explain the informatica workflow?
Is it possible to revert a global repository to local one and why?
r u done any partitions in ur project?
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?
What is exclusive and normal mode for repository services?
What are the designer tools for creating transformations?
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
What is a sorter transformation?
What are the steps involved in the migration from older version to newer version of Informatica Server?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
How to do unit testing in informatica? How to load data in informatica ?
lookup transformation with screenshots