Thread: Load from source to different targets

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

Originally Posted by cme_prak

Hi Raju,

Using Round Robin Partition, we can do that scenario.

Thx,
Prakash

Hi Raju,

Can u please explain me how to use Round robin partition. I am novice to DW and never heard of this before.

Thanks in advance,
Divya

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.