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.
No comments:
Post a Comment