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
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.