Rank Transformation is an active and connected transformation in Informatica Cloud (IICS). It helps in identifying largest or smallest set of values in a group of data by filtering the data and ranking the values.
Procedure:-
- Open SQL server HR data base and check the source table emp_ss by giving the select statement..
- Login to IICS and Click on new mapping.
- Click on create to create new mapping and rename the mapping of your choice for example: m_rankexp
- Click on the source and rename the source name as required.
- In the properties go to source and configure the connections by selecting the required connection name.
- In the Object select the source object and click on ok.
- In the properties go to Source and configure the connections by selecting the required connection name.