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
What are roles and groups and benefits of using them?
Explain lookup transformation in informatica
scenario where i can use only concurrent execution of workflow.
what is unit testing?tell me proceedure
What if the source is a flat-file?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is resilience time?
Differentiate between reusable transformation and mapplet.
Can we create a node as a gateway node and the same node can be assigned to a grid?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How do you load first and last records into target table?
What are different types of transformations available in informatica?
Explain the use of aggregator cache file?
Differences between connected and unconnected lookup?