Saturday, December 8, 2012

Separate the original records in target

Separate the original records in target

Scenario 10: How to separate the original records from source table to separate target table by using rank transformation ?
Source Table
col1 col2 col3
a b c
x y z
a b c
r f u
a b c
v f r
v f r



Target Table
Col1 Col2 Col3
a b c
x y z
r f u
v f r



Solution:
Step 1: Bring the source to mapping.


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


RANK PROPERTY

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

2 comments:

Thank you :
- kareem