I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3r

I have a scenario like - how can i load 1st record to
Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to
repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?

Question Posted / harish

3 Answers
9703 Views
ITC Infotech, TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and agai..

Answer / susanta

Take a sequence generator with Start Value=1,Current
Value=1,End Value=3, Increment By=1 to assign a seqno to
each row. Do not forget to enable the cycle option.

after that take a Router with three groups of
seqno=1,seqno=2 and seqno=3.

Hope this will help u

Is This Answer Correct ?

28 Yes

1 No

I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and agai..

Answer / ks316

Hi all,

I am posting my first post. Excuse me for any
mistakes, In the above answer given i dont think that the
target gets loaded in proper order. According to your
answer all the records gets loaded into all targets.

I think there should be a condition to every group in the
router.

i think the conditio should be like
mod(nextval,3)=0 tgt1
mod(nextval,3)=1 tgt2
mod(nextval,3)=2 tgt3,

pls correct me if i am wrong

Is This Answer Correct ?

7 Yes

1 No

I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and agai..

Answer / avatar dss42b88

for this we use sequence generator t/r,
ex take source emp
targets -emp1,emp2,emp3.
mapping structure

sq->(seq)->exp->rtr->emp1(condition rowid=1)
->emp2(condition rowid=2)
->emp3(condition rowid=3)
in exp t/r add new port and rename it as rowid and connect
to rtr.
note connect next val to rowid(in exp t/r).
in seq t/r change properties like

start value=1
increment by=1
last value=3
currval=1
cycle check it save it.
execute mapping.

Is This Answer Correct ?

3 Yes

3 No

Post New Answer