madhan

• Apr 18th, 2006

 

Rank transformation is used to find the status.ex if we have one sales table and in this if we find more employees selling the same product and we are in need to find the first 5 0r 10 employee who is selling more products.we can go for rank transformation.

swati

• Apr 20th, 2006

 

It is used to filter the data from top/from buttom according to the condition.

kalyan

• May 1st, 2006

 

To arrange records in Hierarchical Order and to selecte TOP or BOTTOM records. It is same as START WITH and CONNECT BY PRIOR clauses.

sandeep

• Jun 29th, 2006

 

It is an active transformation which is used to identify the top and bottom values based on the numerics .by deafult it will create a rankindex port to caliculate the rank

arun singh

• Mar 8th, 2017

 

Use rank transformation to return top or bottom N-no of position, it uses rank cache to perform rank. In rank cache it contains both index as well as data cache.
Index cache contains GROUP BY parts, while data cache contain calculated RANK values.
Rank cache is temporary and is cleaned up at end up session run.

saiteja

• Jul 2nd, 2017

 

Rank is an active and connected transformation rank transformation contain inputport, outputport, variableport, rankport by using rank transformation we can get top (or) bottom ranks
rank transformation