Informatica scenario:How to get top 5 records to target without using rank

Solution:

1.     Drag the source to mapping and connect it to sorter transformation.

2.     Arrange the salary in descending order in sorter as follows and send the record to expression.

3.     Add the next value of sequence generator to expression.(start the value from 1 in sequence generator.

4.     Connect the expression transformation to a filter or router. In the property set the condition as follows-

5.     Finally connect to the target.