17_-_Rank transformation in Informatica

View this thread on: d.buzz | hive.blog | peakd.com | ecency.com
·@ashish.sharma·
0.000 HBD
17_-_Rank transformation in Informatica
<center><a href='https://dtube.video/#!/v/ashish.sharma/xg10jhtj'><img src='https://dtube2.gateway.ipfsstore.it:8443/ipfs/QmT9kjfv8d7uBAUycVwH6EsqeNxenNkrQTUQKuZzUGC7iS'></a></center><hr>Rank transformation is an active and connected transformation that performs the filtering of data based on group and ranks. For example, you want to get ten records of employees having highest salary, such kind of filtering can be done by rank transformation.

Rank transformation also provides the feature to do ranking based on groups. Like if you want to get top ten salaried employee department wise, then this grouping can be done with this transformation.

Rank transformation is an active transformation, as it affects the number of output rows.

The rank transformation has an output port by which it assigns a rank to the rows.<hr><a href='https://dtube.video/#!/v/ashish.sharma/xg10jhtj'>► Watch on DTube</a><br /><a href='https://chappy.i.ipfs.io/ipfs/QmYqJCEcwm3aiUEHs4Jsoib6Sph7Vx6Bvu8QKSVYM9w8bt'>► Watch Source (IPFS)</a>
👍 , ,