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 Posted / 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 View All Answers
How to delete duplicate row using informatica?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is DR strategy for Informatica project?
Explain scd type 3 through mapping.
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What are the reusable transformations?
Which version configuration tool used in ur project?
Suppose we do not group by on any ports of the aggregator what will be the output?
what are the deliverables?in your project?
What is decode in informatica?
Slowly changing dimensions, types and where will you use them
what is Active lock explain
What is the difference between a connected look up and unconnected lookup?
Reusable transformation and shortcut differences
What does role playing dimension mean?