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 / 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 |
Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project
WHAT IS THE DIFFERENCE B/W 7.X AND 8.X ? TELL ME FEW DIFFERENCES.
How to call shell scripts from informatica?
how many data models u have done in informatica project?
How to generate a single mapping for both the historical and incremental load.
Define Incremental Aggregation?
following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000
There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?
surrogate keys usage in Oracle and Informatica?
5 Answers ITC Infotech, Oracle,
How You Pull the records on daily basis into your ETL Server.
explain abt ur project architecture?
0 Answers Anthem, DELL, IBM, TCS, Wipro,
what is row level and column level indicator?