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.

Answers were Sorted based on User's Feedback



Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently R..

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

Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently R..

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

Post New Answer

More Informatica Interview Questions

What is power play plug in?

2 Answers  


I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records

5 Answers   Patni,


I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

0 Answers  


Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?

1 Answers   Wipro,


How to extract sap data using informatica? What is abap? What are idocs?

0 Answers  






I want skip first 5 rows to load in to target? what will be the logic at session level ??

1 Answers   IBM,


My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ram DELHI 2000 hju-hji raj hyd 1000 my target table should be ID Name Location Salary 1 ran tpty 1000 2 ram DELHI 2000 hju-hji raj hyd 1000

3 Answers   TCS,


In which circumstances that informatica server creates Reject files?

2 Answers  


What is the use of an aggregator cache file?

0 Answers  


What is A cache?

2 Answers  


hi,there is a scenario like. there are three columns empid,salmonth, sal contains the values 101,jan,1000 101 feb 1000 like twelve rows are there then my required out put is like contains 13 columns empid jan feb marc.......dec and the velues are 101 1000 1000 1000 like this . thank you

5 Answers   Patni,


How you count the number of records available at your source?

3 Answers   Zensar,


Categories