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
2487 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

I still need further explanation about the difference between active and passive transformation with some examples.Thank You

5 Answers

Define the various join types of joiner transformation?

0 Answers

What are the differences between joiner transformation and source qualifier transformation?

0 Answers Informatica,

ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?

3 Answers HP,

what is the need of session partitioning... how it is useful in real time

3 Answers Amazon,

What is flashback table ? Advance thanks

0 Answers Puma,

Is informatica power center designer has 64 bit support?

1 Answers

What is a configuration management?

1 Answers

hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?

4 Answers

How mapping parameter and variable works

1 Answers

What is parameter file?

2 Answers

If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?

1 Answers TCS,

For more Informatica Interview Questions Click Here