How to get top 5 records to target without using rank ?
Arrange the salary in descending order in sorter as follows and send the record to expression.
Connect the expression transformation to a filter or router. In the property set the condition as follows
Solution:
- Drag the source to mapping and connect it to sorter transformation.
- Add the next value of sequence generator to expression.(start the value from 1 in sequence generator).
Connect the expression transformation to a filter or router. In the property set the condition as follows
- Finally connect to the target.
No comments:
Post a Comment