There are two sessions are connected to the workflow. When the first session run

There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?

Question Posted / veeruch8

1 Answers
2476 Views
Wipro, I also Faced
E-Mail Answers

There are two sessions are connected to the workflow. When the first session run load the data(emplo..

Answer / abhishek

Need to use WF level variable which is a common factor between sessions . Pass value of 1st mapping variable to WF variable & then WF variable value to 2nd Mapping variable to control the behaviour.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer

More Informatica Interview Questions

delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses

2 Answers Motorola,

Quickly characterize reusable change?

0 Answers

Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer

0 Answers

There are 3 groups in router transformation in which there are no conditions mentioned, so what happens if I connect these groups to the 3 targets? How many records gets into each target.(suppose if we are getting 10 records from the source)

4 Answers

how to insert header after each group.

1 Answers IBM,

Can we change Dynamic to Static or Persistent cache? If so what happens?

0 Answers TCS,

Why we select the table which has minimum number of records as Master table in joiner?

4 Answers HG, UST,

When do you use sql override in a lookup transformation?

0 Answers

what are factless facts? And in which scenario will you use such kinds of fact tables.

0 Answers

Explain lookup transformation in informatica