we have 6 records in source , i need 2nd record in one
target and 5th record in one target or 2nd & 5th record in
same target.

Answers were Sorted based on User's Feedback



we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd..

Answer / radha

We can use Router t/r also.
create as many conditions u want.
say, if rownum=2 then flow the data to target 1
if rownum=5 then flow to another target
go on....

Is This Answer Correct ?    8 Yes 3 No

we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd..

Answer / ssrinivas624

any one heard about cume()function...
Using cume() funtction we can achieve this...
take any expresion after source qualifier add a row_cume
port and write an expression like cume(1)...
take a filter t/r write row_cume = 2 OR row_cume = 5 in
condition tab. Like any number of different rows u can
get...

two targets...
--->FILTER--->TARGET1
SQ--->EXP
--->FILTER--->TARGET2

same target...
SQ--->EXP--->FILTER--->TARGET


in the place of two filters u can go for router also...

Is This Answer Correct ?    5 Yes 0 No

we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd..

Answer / lvpr

Another way is to use rank t/r and load data to target by
filtering 2 and 5 rows.

Is This Answer Correct ?    4 Yes 2 No

we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd..

Answer / lvpr

Use two pipe lines...first pipeline add sequence gen t/r
and send data to dummy target...

In second pipeline take first pipe line's target as source
as we have seq numbers for each row now route 2 and 5 row
to diff target's or to same target

Is This Answer Correct ?    2 Yes 2 No

we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd..

Answer / lokesh

src->sq->seq_gen->exp->flt->targer

in seq_gen property's put cycle 3,

write a condition as a nextlevel=2, insert into target.

Is This Answer Correct ?    0 Yes 0 No

we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd..

Answer / raja

by using router it solve it.it is the best method to insert the data in to each target.

Is This Answer Correct ?    0 Yes 0 No

we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd..

Answer / pavan

using Router transformation we can solve this.
create as many conditions u want.
Suppose,if rownum=2 then flow the data to target 1
if rownum=5 then flow to another target
go on....

Is This Answer Correct ?    0 Yes 0 No

we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd..

Answer / sateesh

Source-->SQ-->SequenceGenerator-->Exp-->Rtr-->Target

In Exp Transformation assign a variable port like v_num=10;

In Rtr Transformation use defined group give a condition
like

IIF(curvar>1,IIF(Mod(v_num,curvar)=0,0,1),1)

Please correct me if am wrong.

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More Informatica Interview Questions

What are differences between Informatica 7.1 and 6.1

3 Answers  


What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.

4 Answers   JPMorgan Chase,


explain about unit testing? in real time?

0 Answers   L&T,


What are the diffrences between joiner transformation and source qualifier transformation?

2 Answers  


What is a repository? And how to add it in an informatica client?

0 Answers   Informatica,






How to import oracle sequence into Informatica?

3 Answers   Satyam,


What is decode in static cache?

0 Answers  


Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio

4 Answers   IBM,


source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks

4 Answers   Polaris,


IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?

2 Answers  


When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?

2 Answers   TCS,


To achieve the session partition what r the necessary tasks u have to do?

1 Answers  


Categories