...

• Rank values start at 1 and increment.

• Ranking order varies depending on the data type of the source data. For more information, see Sort Order.

• You must use the group and order parameters to define the groups of records and the ordering column to which this function is applied. 

• This function works with the following transforms:
  • Window Transform
  • Set Transform
  • Derive Transform
• This function assigns ranking values to match the total number of rows in a group. If needed, tie values can be assigned the same rank. For more information, see DENSERANK Function.

...