Scenario 12: How to get top 5 records to target without using rank ?
- Drag the source to mapping and connect it to sorter transformation.
- Arrange the salary in descending order in sorter as follows and send the record to expression.
- 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.