Pages

Sunday, March 17, 2013

How to send alternate record to target || Sending Odd numbered records to one target and even numbered records to another target.


Step 1: Drag the source and connect to an expression transformation.
Step2: Add the next value of a sequence generator to expression transformation.                                                                                       
scr to seq mapping
SCR TO SEQ MAPPING

Step 3: In expression transformation make two port, one is "odd" and another "even".
And Write the expression like below
expression property
EXPRESSION PROPERTY

Step 4: Connect a router transformation to expression.
Make two group in router.
And give condition  Like below
rtr property
RTR PROPERTY

Step 5: Then send the two group to different targets.
The entire mapping is as below
Final mapping view scenario 9

No comments:

Post a Comment