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

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

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.

Question Posted / seenu

8 Answers
10191 Views
I also Faced
E-Mail Answers

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