What is Rank Transformation?
Rank change is a functioning and associated change that plays out the sifting of information in view of gathering and positions. For instance, you need to get ten records of workers having the most significant pay, such sort of separation should be possible by the rank change.
Rank change likewise gives the component to do positioning in light of gatherings. Like to get top ten salaried representatives office-wise, then this gathering should be possible with this change.
Rank change is a functioning change, as it influences the number of result columns.
The position change has a result port by which it relegates a position to the lines.
Our prerequisite is to stack the top 3 salaried workers for every office; we will carry out this utilizing rank change.
Stage 1 - Create a plan having source EMP and target EMP_TARGET
Stage 2-Then in the planning
Select change menu
Select make choice
Stage 3 - In the make change window
Rank Transformation in Informatica serves as a valuable tool
for sorting and ranking data rows based on specified criteria. This
transformation allows you to determine the relative positions or rankings of
data rows within a dataset. In this article, we will explore the significance,
functionality, and practical applications of the Rank Transformation in
Informatica.
Understanding the Rank Transformation
What is the Rank Transformation?
The Rank Transformation in Informatica is a vital component
that enables you to sort and rank data rows based on one or more attributes. It
assigns a rank value to each data row, indicating its position within the
sorted dataset. The rank can be assigned in ascending or descending order,
depending on the criteria you define.
Key Functions of Rank Transformation
The Rank Transformation offers several key functions:
Configuration and Usage
Configuration Steps
To configure the Rank Transformation effectively, follow
these steps:
1. Create
Input and Output Ports: Define input and output ports for the Rank
Transformation. Input ports receive data rows, and output ports represent the
ranked data.
2. Sorting
Criteria: Specify the attributes by which you want to sort the data. You
can define multiple sorting criteria to create complex ranking rules.
3. Ranking
Order: Determine whether the ranking should be in ascending or descending
order for each sorting attribute.
Practical Applications
The Rank Transformation is versatile and finds applications
in various scenarios:
Performance Considerations
Efficiency is crucial when working with the Rank
Transformation:
Select position change
Enter change name "rnk_salary"
Select Create button
Stage 4 - The position change will be made in the planning, select done fasten in the window
Stage 5 - Connect every one of the ports from the source qualifier to the position change
Stage 6-Double snap on the position change and it will open the "alter change window". In this window
Select properties menu
Select "Top" choice from the Top/Bottom property
Enter 3 in the number of positions
Stage 7 - In the "alter change" window once more
Select ports tab
Select gathering by choice for the Department number section
Select Rank in the Salary Column
Select alright button
Stage 8 - Connect the ports from rank change to the objective table
Rank Transformation in Informatica with EXAMPLE
Presently, save the planning and execute it subsequent to making meetings and work processes. The source qualifier will get every one of the records, yet rank change will pass just records having three significant compensations for every division.
Workflow Monitor in Informatica |
Workflows In Informatica |
Mappings in Informatica |
Source Analyzer and Target Designer in Informatica |