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?



I have some rows in source.I have to map half rows to one target and half rows to another target.i.e..

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

Post New Answer

More Informatica Interview Questions

what are cost based and rule based approaches and what is the difference?

1 Answers  


How are the sources and targets definitions imported in informatica designer?

0 Answers   Informatica,


If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks

7 Answers   Puma,


Write the prerequisite tasks to achieve the session partition?

0 Answers  


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...

3 Answers  






what is semi-additive fact?where did u used?

2 Answers  


How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?

2 Answers  


Reusable transformation and shortcut differences

0 Answers  


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?

9 Answers   Cap Gemini,


What are the various types of transformation?

0 Answers  


How to retrieve last two days updated records?

4 Answers  


In which situation we will use persistant cache and shared cache in real time. plzsss answer with example

1 Answers   Wipro,


Categories