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?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.
No comments:
Post a Comment