Draw a workflow diagram for this situation. If s3 is true
session s4 and s5 should concurreently Run.if any one s4 or
s5 true it should run s1.If s1 sucess it should execute s2
otherwise exit.can any one give me suggestion.Thanks in
advance.
Answer Posted / vaibhav bhandeo
1. Run S3.
2. Connect it to S4 and S5. Check if PreviousTaskStatusS3 =
succeeded in the connecting link.
3. Once S3 is successfully executed it will start S4 and S5
4. Use a decision task and input that from S4 and S5. In
the decision use
PreviousTaskStatusS4 = succeeded or PreviousTaskStatusS5 =
succeeded
5. This will allow you to move ahead incase either of S4 or
S5 is succeeded.
6.Connect it to S1 using the same PreviousTaskStatus =
succeeded.
7.Connect it to S2 using the same PreviousTaskStatus =
succeeded.
This way the required job will be done.
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
Differentiate between reusable transformation and mapplet.
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is pmcmd command?
How to handle decimal places while importing a flatfile into informatica?
Please let me know how to make Data masking in informatica..
How can we use mapping variables in informatica?
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
Is it possible to create multiple domains on a single Informatica server?
What is the difference between writing a joiner query in ANSI style and THETA style?
Describe the impact of several join conditions and join order in a joiner transformation?
What is a sequence generator transformation?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
without table how to come first record only in oracle?
How do you load first and last records into target table?
What happens when a session fails and you click on recover?