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?



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

What is workflow? What are the components of the workflow manager?

0 Answers  


hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks... Send me----: raghukrams@yahoo.com

0 Answers  


how the informatica server sorts the strings values in rank transformations?

3 Answers   TCS,


task is running successfully but data is not loded why?

2 Answers  


What is surrogate key?

9 Answers  






Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.

7 Answers   Cognizant, Wipro,


WHAT IS THE DIFFERENCE B/W 7.X AND 8.X ? TELL ME FEW DIFFERENCES.

2 Answers  


how to run 2 workflows sequentially. plz respond what is the process?

9 Answers   Cap Gemini, Target,


What are partitions in informatica and which one is used for better performance?

2 Answers  


what is the use of Data Mart?

5 Answers   IBM,


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

2 Answers   Sapient,


explain one complex mapping with logic? sales project?

0 Answers   Accenture, JPMorgan Chase,


Categories