I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?
Answer / dilip ingole
use sql override in SQ
ans use query as fellow
SELECT NUM,CASE WHEN ROWNUM <=(SELECT COUNT(1)/2 FROM TABLE_NAME) THEN 1 ELSE 0 END FLAG FROM TABLE_NAME;
in informatica filter record based on flag if flag is 1 then send it to one target else to second target
Is This Answer Correct ? | 0 Yes | 0 No |
what are cost based and rule based approaches and what is the difference?
How are the sources and targets definitions imported in informatica designer?
If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks
Write the prerequisite tasks to achieve the session partition?
Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...
what is semi-additive fact?where did u used?
How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?
Reusable transformation and shortcut differences
i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?
What are the various types of transformation?
How to retrieve last two days updated records?
In which situation we will use persistant cache and shared cache in real time. plzsss answer with example