Friday, 21 March 2014

How to fetch top 4th to 13th ranked employees based on condition using rank transformation?

Source def->source qualifier ->seq generator->rank transformation -> filter-> target definition.
In this mapping after source qualifier sequence generator and rank transformation are parallel.
In rank transformation properties select type is "top" and number of ranks 13
Then in filter transformation write a condition Nextval>=4
Then u can get 4th to 13th ranks.....


Thanks 
Ur's Hari

No comments:

Post a Comment