100 records in source and i have 3 targets, my requirement is first record inse

100 records in source and i have 3 targets, my requirement
is first record insert into 1st target,2 record into 2nd
target,3 record into 3rd target and again 4th record into
1st target like dat..how to implement dis?

Question Posted / siva reddy

3 Answers
10383 Views
Polaris, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2..

Answer / manthiramoorthy. g

SQ-->EXP-SEQ-RTR-TARGETS

Router
=======
Make 3 Groups
MOD(NEXTVAL,3) = 0
MOD(NEXTVAL,3) = 1
MOD(NEXTVAL,3) = 2

Is This Answer Correct ?

13 Yes

2 No

100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2..

Answer / mayur

SQ==>Sequence Generator(make it cycle of three)==> Filter
Tr==> Target

Is This Answer Correct ?

1 Yes

0 No

100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2..

Answer / chandra

SQ--->EXP-->ROUTER---->TARs

In EXP take 2 output ports ,In one output port write
mod(id,3)=1and second Oport write mod(id,3)=2..,
Next drag the ports to ROUTER
In router take 2 groups ,IN first group write condition
mod(id,1)=1
and second group write condition mod(id,3)=2
finaly drag 3output groups into 3targets

Is This Answer Correct ?

3 Yes

3 No

Post New Answer