We have one source and 3 targets with same fields i.e empno,ename in all 3 targets and source, then the 1st row in source should go to 1st target, 2nd row in source should go to 2nd target and the 3rd row in source should go to 3rd target, 4th row again to 1st target , 5th row to target2 6th row to target 3 like this we need to transfer data how is it possible?
Total Answers and Comments: 3
Last Update: January 14, 2008 Asked by: mailtos.ravi
RE: Informatica source and targets with same fields
then it is better for u to use the router transformation and depeneding upon the condition the router transforms the required input fromthe source tothe target
RE: Informatica source and targets with same fields
here we should use router transformation with 3 groups. suppose 3 targets are target1: condition multiples of 3 Â Â Â Â Â Â Â Â Â Â select * from emp where (empno,0) in (select empno,mod(rownum,3) from emp target2: condition rows which are leaves remainder 1 when divide by 3 Â Â Â Â Â Â Â Â Â Â select * from emp where (empno,1) in (select empno,mod(rownum,3) from emp target3: condition for rows which are leaves remainder 2 when divide by 3 Â Â Â Â Â Â Â Â Â Â Â select * from emp where (empno,2) in (select empno,mod(rownum,3) from emp
RE: Informatica source and targets with same fields
First Load Data from source To One dummy table in target with SEQ Gen T/R. in SEQ Gen T/R Set min value 1 and max value 3 and check the reset option. It will load the data with new column Values 1,2,3,1,2,3........... Then use that dummy table as a source And use a router T/R in This mapping pipeline. put Condition In router T/R, with three groups and load data in three different Trgets. I think this should work.
