I have some rows in source.I have to map half rows to one target and half rows t

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?

Question Posted / teja.inf

1 Answers
3564 Views
Franklin Templeton, I also Faced
E-Mail Answers

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

Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?

2 Answers Deloitte,

What is option by which we can run all the sessions in a batch simultaneously?

0 Answers Informatica,

How to get rid of non ascii characters in a string? Ex:- United States Microsoft Visual Studio Tools for Applications 2012 x86 主控支援 - 繁體中文語言套件 to United States Microsoft Visual Studio Tools for Applications 2012 x86.

1 Answers CTS,

how many repositories can v create in informatica .

3 Answers Cap Gemini, Tech Mahindra,

Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u

3 Answers

What are the databases that informatica can connect to windows?

0 Answers

Without source how to insert record to target?

6 Answers

i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario

4 Answers Polaris,

If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?

8 Answers HeadStrong, TCS,

how to import multiple flat files in to single target where there is no common column in the flat files

2 Answers TCS,

write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690

2 Answers TCS,

in reporting we add some new objects,how we get the count of the newly added objects to the report

0 Answers HP,

For more Informatica Interview Questions Click Here