Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 1 Answers
- 2539 Views
- Wipro, I also Faced
- E-Mail Answers
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
differences between service based and product based?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What are the differences between oltp and olap?
What is the maplet?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is lookup transformation?
What is the function of union transformation?
What is resilience time?
what are the Methods For Creating Reusable Transformations?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What differs when we choose the sorted input for aggregator transformation?
What is a stored procedure transformation?
Why update strategy and union transformations are active?
Enlist the tasks for which source qualifier transformation is used.
how to create user defined function (udf) in informatica
