in my source i have 100 records, and 3 targets, i want to load 1st record i

in my source i have 100 records, and 3 targets, i want to
load
1st record into 1st target,2nd record into 2nd target,3rd
record into 3rd target again 4th target into 1st target and
vice versa,how to achieve this?

Question Posted / ameen

3 Answers
13387 Views
Thomson Reuters, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd r..

Answer / venkatesh.malneni

here we want to conform one thing that's is there serial no
or not
if there is serial no then we can just take a router then
create three(3) groups
First group for First target
Second is for second target
Third is for third target
write the condition as fallows
mod(s.no,3)=1-------> first target
mod(s.no,3)=2--------> second target
mod(s.no,3)=0-------->third target
if there is no s.no in source then create s.no by using
sequence generator t/r

the flow will be as fallows
/--------->t1
src--->sq---->router/----------->t2
\------------>t3

or if u use sequence generator the flow will be

sequqncegenerator
| /--------->t1
src--->sq---->router/----------->t2
\------------>t3

Is This Answer Correct ?

16 Yes

0 No

in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd r..

Answer / chandra

this can be done in two ways.....
1st one

after the SQ we can take EXP Tr
in EXP take one output port like O_SEQ
before EXP Tr take SGT Tr ...
In SGT properties enable cycling and
set START VAL 1 and END VAL 3
then connect the NEXVAL port into O_SEQ port of EXP Tr
after that take ROUTER Tr
in ROU Tr take 3 groups
1st group put condition as O_SEQ=1
2ns group O_SEQ=2 and
3 rd O_SEQ=3
and then drag the 1 st group data into TRG1
2nd group data into TRG2
and 3rd group data into TRG3

the fllow will be like
SRC--->SQ--->SGT--->EXP--->ROU-->TRG1
---> TRG2
--->TRG3

or
we can use MOD function in EXP Tr we can done this

Is This Answer Correct ?

8 Yes

0 No

in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd r..

Answer / ankur saini er.ankur861@gmail.

i think the best way to achieve this is to add a cyclic
sequecn gen which will gen 1,2,3 again 1,2,3 again 1,2,3

addd a router then or 3 filters add dump the the data from
sep filters or router groups to the diff targets as
required..

Thanks...

Is This Answer Correct ?

2 Yes

0 No

Post New Answer