The Rank transformation is used to get a specific number of records from the top or bottom. Consider that you need to take the top five salaried employees from the
EMPLOYEE table. You can use the Rank transformation and define the property. A sample mapping indicating the Rank transformation is shown in the following screenshot:
When you create a Rank transformation, a default
RANKINDEX output port comes with the transformation. It is not mandatory to use the
RANKINDEX port. We have connected the
RANKINDEX port to the target as we wish to give the rank of
EMPLOYEES based on their
When you use a Rank transformation, ...