Rank is a lively and connected transformation that performs the filtering of data supported the group and ranks. The rank transformation also provides the feature to try to ranking supported groups.

The rank transformation has an output port, and it’s wont to assign a rank to the rows.

In Informatica, it’s wont to select a bottom or top range of data. While string value ports are often ranked, the Informatica Rank Transformation is employed to rank numeric port values. One might think MAX and MIN functions can accomplish this same task.

However, the rank transformation allows groups of records to be listed rather than one value or record. The rank transformation is made with the subsequent sorts of ports.

Input port (I)
Output port (O)
Variable port (V)
Rank Port (R)

Rank Port

The port which is participated during a rank calculation is understood as Rank port.

Variable Port

A port that permits us to develop expression to store the info temporarily for rank calculation is understood as a variable port.

The variable port will enable us to write down expressions that are required for rank calculation.

Ports during a Rank Transformation

Ports	Number Required	Description
I	1 Minimum	Port to receive data from another transformation.
O	1 Minimum	Port we want to pass to other transformations.
V	not needed	It is used to store values or calculations to be used in an expression.
R	Only 1	The Rank port is an input or output port. We have linked the Rank port to different transformation. For example: Total Salary

Configuring the Rank Transformation

Let’s see the way to configure the subsequent properties of Rank transformation:

Cache Directory: The directory may be a space where the mixing service creates the index and data cache files.
Top/Bottom: It specifies whether we would like to pick the highest or bottom rank of data .
Number of Ranks: It specifies the amount of rows that we would like to rank.
Case-Sensitive String Comparison: it’s wont to sort the strings by using the case sensitive.
Tracing Level: the quantity of logging to be tracked within the session log file.
Rank Data Cache Size: the info cache size default value is 2,000,000 bytes. we will set a numeric value or Auto for the info cache size. within the case of Auto, the mixing Service determines the cache size at runtime.
Rank Index Cache Size: The index cache size default value is 1,000,000 bytes. we will set a numeric value or Auto for the index cache size. within the case of Auto, the mixing Service determines the cache size at runtime.

What is Rank Index?

The Developer tool creates a rank index port for every Rank transformation. the info Integration Service uses the Rank Index port to store the ranking position for every row during a group.

After the Rank transformation identifies all rows that belong to a top or bottom rank, it then assigns rank index values. If two rank values match, they receive an equivalent value within the rank index, and therefore the transformation skips subsequent value.

The rank index is an output port only. we will pass the rank index to a different transformation within the mapping or on to a target.

Defining Groups

The Rank transformation gives us group information just like the aggregator transformation.

For example: If we would like to pick the 20 costliest items by manufacturer, we might first define a gaggle for every manufacturer.

Example

Suppose we would like to load top 5 salaried employees for every department; we’ll implement this using rank transformation within the following steps, such as:

Step 1: Create a mapping having source EMP and target EMP_TARGET

Step 2: Then within the mapping,

Select the transformation menu.
and click on the Create option.

Step 3: within the create transformation window,

Select rank transformation.
Enter transformation name “rnk_salary”.
and click on the Create button.

Step 4: The rank transformation are going to be created within the mapping, select the done button within the window.

Step 5: Connect all the ports from source qualifier to the rank transformation.

Step 6: Double click on the rank transformation, and it’ll open the “edit transformation window”. during this window,

Select the properties menu.
Select the “Top” option from the Top/Bottom property.
Enter 5 within the number of ranks.

Step 7: within the “edit transformation” window again,

Select the ports tab.
Select group by option for the Department number column.
Select Rank within the Salary Column.
Click on the OK button.

Step 8: Connect the ports from rank transformation to the target table.

Now, save the mapping and execute it after creating session and workflow. The source qualifier will fetch all the records, but the rank transformation will pass only records having three high salaries for every department.

So, this brings us to the end of blog. This Tecklearn ‘Rank Transformation in Informatica’ blog helps you with commonly asked questions if you are looking out for a job in Informatica. If you wish to learn Informatica and build a career in Datawarehouse and ETL domain, then check out our interactive, Informatica Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

https://www.tecklearn.com/course/informatica-training-and-certification/

Informatica Training

About the Course

Tecklearn’s Informatica Training will help you master Data Integration concepts such as ETL and Data Mining using Informatica PowerCenter. It will also make you proficient in Advanced Transformations, Informatica Architecture, Data Migration, Performance Tuning, Installation & Configuration of Informatica PowerCenter. You will get trained in Workflow Informatica, data warehousing, Repository Management and other processes.

Why Should you take Informatica Training?

Informatica professionals earn up to $130,000 per year – Indeed.com
GE, eBay, PayPal, FedEx, EMC, Siemens, BNY Mellon & other top Fortune 500 companies use Informatica.
Key advantages of Informatica PowerCenter: Excellent GUI interfaces for Administration, ETL Design, Job Scheduling, Session monitoring, Debugging, etc.

What you will Learn in this Course?

Informatica PowerCenter 10 – An Overview

Informatica & Informatica Product Suite
Informatica PowerCenter as ETL Tool
Informatica PowerCenter Architecture
Component-based development techniques

Data Integration and Data Warehousing Fundamentals

Data Integration Concepts
Data Profile and Data Quality Management
ETL and ETL architecture
Brief on Data Warehousing

Informatica Installation and Configuration

Configuring the Informatica tool
How to install the Informatica operational administration activities and integration services

Informatica PowerCenter Transformations

Visualize PowerCenter Client Tools
Data Flow
Create and Execute Mapping
Transformations and their usage
Hands On

Informatica PowerCenter Tasks & Workflows

Informatica PowerCenter Workflow Manager
Reusability and Scheduling in Workflow Manager
Workflow Task and job handling
Flow within a Workflow
Components of Workflow Monitor

Advanced Transformations

Look Up Transformation
Active and Passive Transformation
Joiner Transformation
Types of Caches
Hands On

More Advanced Transformations – SQL (Pre-SQL and Post-SQL)

Load Types – Bulk, Normal
Reusable and Non-Reusable Sessions
Categories for Transformation
Various Types of Transformation – Filter, Expression, Update Strategy, Sorter, Router, XML, HTTP, Transaction Control

Various Types of Transformation – Rank, Union, Stored Procedure

Error Handling and Recovery in Informatica
High Availability and Failover in Informatica
Best Practices in Informatica
Debugger
Performance Tuning

Performance Tuning, Design Principles & Caches

Performance Tuning Methodology
Mapping design tips & tricks
Caching & Memory Optimization
Partition & Pushdown Optimization
Design Principles & Best Practices

Informatica PowerCenter Repository Management

Repository Manager tool (functionalities, create and delete, migrate components)
PowerCenter Repository Maintenance

Informatica Administration & Security

Features of PowerCenter 10
Overview of the PowerCenter Administration Console
Integration and repository service properties
Services in the Administration Console (services, handle locks)
Users and groups

Command Line Utilities

Infacmd, infasetup, pmcmd, pmrep
Automate tasks via command-line programs

More Advanced Transformations – XML

Java Transformation
HTTP Transformation

Got a question for us? Please mention it in the comments section and we will get back to you.

583