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