Rank Transformation

Rank Transformation is Active and Connected Transformation. It is used to rank the list of the records in a table. We can rank top and bottom records in a table based on our requirement. If we want to get bottom records we select bottom option and wise versa.

Cache files created:-

----------------------- 

There are 2 different Cache files created with Rank transformation 

- Index Cache : Index Cache stores group values configured in group by ports.

- Data Cache : Data Cache stores ranking information based on group by ports.

Steps to create rank transformation :-
- In the mapping designer, create a new mapping or open an existing mapping
- Go to Toolbar->click Transformation -> Create. Select the Rank transformation
- Enter a name, click on Create and then click on Done
- By default, the rank transformation creates a RANKINDEX port. The RankIndex port is used to store the ranking position of each row in the group
- You can add additional ports to the rank transformation either by selecting and dragging ports from other transformations or by adding the ports manually in the ports tab
- In the ports tab, check the Rank (R) option for the port which you want to do ranking. You can check the Rank (R) option for only one port. Optionally you can create the groups for ranked rows. select the Group By option for the ports that define the groups