Database Reference
In-Depth Information
The Rank transformation
The Rank transformation is used to get a specific number of records from the top or bot-
tom. 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 in-
dicating 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
SALARY
.
When you use a Rank transformation, you need to define the port on which you wish to
rank the data. As shown in the following screenshot, we have ranked the data based on
SALARY
: