What is a RANK port and RANKINDEX?

Ans. Rank port is an input/output port use to specify the column for which we want to rank the source values. By default Informatica creates an output port RANKINDEX for each Rank transformation. It stores the ranking position for each row in a group.

How does a Rank Transform differ from Aggregator Transform functions MAX and MIN?

Like the Aggregator transformation, the Rank transformation lets us group information. The Rank Transform allows us to select a group of top or bottom values, not just one value as in case of Aggregator MAX, MIN functions.

What is a Rank Transform?

 Rank is an Active Connected Informatica transformation used to select a set of top or bottom values of data.

What happens if two rank values match?

If two rank values match, they receive the same value in the rank index and the transformation skips the next value.

How does a Rank Cache works?

During a session, the Integration Service compares an input row with rows in the data cache. If the input row out-ranks a cached row, the Integration Service replaces the cached row with the input row. If we configure the Rank transformation to rank based on different groups, the Integration Service ranks incrementally for each group it finds. The Integration Service creates an index cache to stores the group information and data cache for the row data

How can you get ranks based on different groups?

Ans. Rank transformation lets us group information. We can configure one of its input/output ports as a group by port. For each unique value in the group port, the transformation creates a group of rows falling within the rank definition (top or bottom, and a particular number in each rank).