When you define the rank properties for a Rank transformation, you select the field to rank by, specify the rank order, and specify number of rows to rank by. Define rank properties on the
Rank
tab.
The following image shows the
Rank
tab:
Configure the following properties:
Rank By
Specify the field that you want to use for ranking in the
Rank By
field.
For example, you create a Rank transformation to rank the top 10 employees in each department based on salary. The EMP_SALARY field contains the salary for each employee. Select EMP_SALARY as the
Rank By
field.
In advanced mode, the
Rank By
field can’t be a binary data type.
Rank Order
Specify the rank order in the
Rank Order
field. Select
Top
or
Bottom
.
Number of Rows
Specify the number of rows to include in each rank group in the
Number of Rows
field. For example, to rank the top 10 employees in each department based on salary, enter 10 in the
Number of Rows
field.
You can use a parameter to specify the number of rows. To use a parameter, select