Pages

Sunday, March 17, 2013

How to separate the original records from source table to separate target table by using rank transformation ?


Source Table:
col1col2col3
a
bc
xyz
abc
rfu
abc
vfr
vfr








Target Table
Col1Col2Col3
abc
xyz
rfu
vfr





Solution: 
Step 1: Bring the source to mapping.
src to rank mapping
SRC TO RANK MAPPING

Step 2: Connect the rank to source.
Step 3: In rank, set the property like this.
rank property
RANK PROPERTY

Step 4: Then send it to target.
Run the session to see the result.

No comments:

Post a Comment