In Dept table there are four departments (dept no 40,30,20,10). Separate the record to different target department wise. Solution: Step 1: Drag the source to mapping. Step 2: Connect the router transformation to source and in router make 4 groups and give condition like below.

In Dept table there are four departments (dept no 40,30,20,10). Separate the record to different target department wise.

Solution:

Step 1: Drag the source to mapping.

Step 2: Connect the router transformation to source and in router make 4 groups and give condition like below.

Step 3: Based on the group map it to different target.

The final mapping looks like below.