What is the Rank index port in Rank transformation?

devquora
devquora

Posted On: Feb 22, 2018

 

Rank transformation is an active and Connected transformation. it is used to select bottom or top rank of data this means to select the smallest or largest numeric value in a group or port. rank index port used by Informatica server to store the rank position for each record A Designer can create a rank index port automatically for each rank transformation.For Example, if you create a Rank Transformation that ranks the top 10 products for each quarter, then the rank index numbers products from 1-10.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Informatica Interview Questions

    In warehouses how many schemas are there?

    There are four Schema’s They are: Star Schema Snow Flake Schema Galaxy Schema Fact Constellation Schema ..

    Informatica Interview Questions

    Could you explain what is Enterprise data warehouse?

    In enterprise data warehousing all organization data is created at a single point of access .data can be provided a glo..

    Informatica Interview Questions

    What is different between the data warehouse and data mart?

    A Data Mart Is a simple form of a data warehouse that is focused on a single subject or functional areas such as sales ..