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
- 2419 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 |
what is the function of 'F10' informatica ?
why we are using surogate key in real time give me explanation
Which one is better performance wise connected/un-connected lkp?why?
Hi, In Router transformation I created two groups . One is Passthrough=> True Second one is CorrectId’s => Invest>50000 Here I have one doubt. Can’t I treat default group as Passthrough group (fist group) . Is there any difference between default group and Passthrough group in this scenario? Let me know if you want more information about this scenario. Advance thanks.
replace multiple spaces with single space.
How can one identify whether mapping is correct or not without connecting session?
If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)
what are the unix commands to start the wrk flow ?
On which transformations you created partitions in your project?
How do you change a non-reusable transformation to reusable transformation?
Teradata 
