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?
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 |
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
How do you load only null records into target? Explain through mapping flow.
Can yoU use the maping parameters or variables created in one maping into another maping?
how we do performence tuning in informatica
how to obtain performance data for individual transformations.
explain about session partitions ?
What are the measure objects?
Define Update Override?
I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?
WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com
wat are deployement groups in informatica, how it will be used for developers
Which is costliest transformation? costly means occupying more memory?