Friday, March 30, 2012

Separate rows on group basis

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.

router transformation
router transformation

Step 3: Based on the group map it to different target. The final mapping looks like below.

router to target
router to target

0 comments:

Post a Comment

newer post older post Home