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.
- 2 Answers
- 8193 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / pg
1. Create S3.
2. Connect it to S4 and S5 prallell. Check if
PreviousTaskStatusS3 =
succeeded in the connecting link.
3. Once S3 is successfully executed it will start S4 and S5
4. Connect s4 and s5 to session s1 and Check if
PreviousTaskStatusS3 =
succeeded in the connecting link and in general tab of
session choose the option treat
input rows as 'OR' .
5. This will allow you to move ahead incase either of S4 or
S5 is succeeded.
6.Connect it to S2 using the same PreviousTaskStatus =
succeeded in the lnk.
| Is This Answer Correct ? | 0 Yes | 2 No |
What are the types of error logs available in Informatica?
Can we use the mapping parameters or variables created in one mapping into another mapping?
Mention a few design and development best practices for informatica?
how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table
I have source like this 1:2;3. so i want to load the target as 123
Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...
How to generate sequence numbers?
What are the types of caches in lookup? Explain them.
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.
Where are the source flat files kept before running the session?
How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!
Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin
Teradata 
