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
- 2457 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?
How do you do error handling in Informatica?
How to use procedural logic inside infromatica?
how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table
What are different types of transformations available in informatica?
Without source how to insert record to target?
In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?
How You Pull the records on daily basis into your ETL Server.
without table how to come first record only in oracle?
Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u
what are the differences between powercenter 8.1 and powercenter 8.5?
How to do Integration testing in Informatica?
Teradata 
