komalahanumantharao

 Profile Answers by komalahanumantharao Questions by komalahanumantharao

• Dec 25th, 2007

 

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

sekhar.ganta

 Profile Answers by sekhar.ganta Questions by sekhar.ganta

• Jan 3rd, 2008

 

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

  

sandeep.vaishy

 Profile Answers by sandeep.vaishy 

• Jan 14th, 2008

 

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.