Q23 In source  there are some record. Suppose I want to send three targets. First record will go to first target, Second one will go to second target and third record will go to third target and then 4th to 1st,5th to 2nd , 6th to  3rd and so on.

  1. Put the source to mapping and connect it to an expression transformation.
    final mapping
  2. Drag an sequence generator transformation and set properties like this And connect  the next value port to expression.
    sequence generator property
  3. Drag all output port of expression to router. In router make three groups and gve the conditions Like this router condition
  4. connect desire group to desire target .