Scenario
I have one table with 100 records. I have 5 diff targets.. From the source the first row should go to 1 target , II row to II target etc V th row to 5 th tgt.. Again 6 th row to 1 , 7 row to 2 tgt.. etc.. How to do this?
Scenario
I have one table with 100 records. I have 5 diff targets.. From the source the first row should go to 1 target , II row to II target etc V th row to 5 th tgt.. Again 6 th row to 1 , 7 row to 2 tgt.. etc.. How to do this?
Hi Raju,
Using Round Robin Partition, we can do that scenario.
Thx,
Prakash
I dnt know about Round Robin thing. You can achive this by using sequence generator transformation..
1) Import ur source table.
2) create a sequence generator transformation start by one n increment by one.
3) create expression transformation, get mod(NEXTVAL,5). Next one more field use decode function DECODE(mod_value,1,1,2,2,3,3,4,4,0,5)
4) Then pass them to router to route them to different targets based on decode value.