Transformations > Rank transformation > Defining rank properties
  

Defining rank properties

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:
The Rank tab of the Rank transformation defines the rank properties. In this example, the Rank By field is "EMP_SALARY," the rank order is "Top," and the number of rows is "10." Therefore, the transformation ranks the top 10 employees based on the values in the EMP_SALARY field.
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 Parameterized in the Parameterize Number of Rows field, and enter the parameter in the Parameter field.