Why rank transformation is active

Report a Bug. Previous Prev. Next Continue. Home Testing Expand child menu Expand. SAP Expand child menu Expand. While doing group by we are doing it in asc order. So bottom 2 will give highest earners right? Post a Comment. Facebook Twitter. Rank transformation is an active and connected transformation. The rank transformation is used to select the top or bottom rank of data.

The integration service caches the input data and then performs the rank calculations. Creating Rank Transformation Follow the below steps to create an expression transformation In the mapping designer, create a new mapping or open an existing mapping. Select the Rank transformation. Enter a name, click on Create and then click on Done. The RankIndex port is used to store the ranking position of each row in the group. The Rank transformation is an active transformation.

Use a Rank transformation to return the largest or smallest numeric value in a port or group. You can also use a Rank transformation to return the strings at the top or the bottom of a session sort order.

During the session, the Integration Service caches input data until it can perform the rank calculations. The Rank transformation differs from the transformation functions MAX and MIN, in that it lets you select a group of top or bottom values, not just one value.

For example, use Rank to select the top 10 salespersons in a given territory. Or, to generate a financial report, you might also use a Rank transformation to identify the three departments with the lowest expenses in salaries and overhead. While the SQL language provides many functions designed to handle groups of data, identifying top or bottom strata within a set of rows is not possible using standard SQL functions.

You connect all ports representing the same row set to the transformation. Only the rows that fall within that rank, based on some measure you set when you configure the transformation, pass through the Rank transformation. You can also write expressions to transform data or perform calculations. The following figure shows a mapping that passes employee data from a human resources table through a Rank transformation.

The Rank transformation only passes the rows for the top 10 highest paid employees to the next transformation. Informatica - PowerCenter Repository Service. What is PowerCenter Repository Manager. What is informatica PowerCenter Designer? Informatica - DTM Threads.

Informatica - Load Balancing. Different ETL tools in Informatica. What is Mapping architect for Visio? Informatica - PowerCenter Informatica - Creating Integration Service.

Creating Informatica Repository Service. Configuring Client Domain in Informatica. Creating Source Analyzer in Informatica. Creating Target designer in Informatica. Create Users and Folders in Informatica. Setting up Target Database in Informatica. Learn and Create Workflows in Informatica.