Rank Index Cache Size: The index cache size default value is 1,000,000 bytes. In case of Auto, the Integration Service determines the cache size at runtime. You can set a numeric value or Auto for the data cache size. Rank Data Cache Size: The data cache size default value is 2,000,000 bytes. Tracing Level: Amount of logging to be tracked in the session log file. Number of Ranks: specify the number of rows you want to rank.Ĭase-Sensitive String Comparison: Used to sort the strings using case sensitive or not. Top/Bottom: Specify whether you want to select the top or bottom rank of data. Example: Total SalaryĬonfigure the following properties of Rank transformationĬache Directory: Directory where the integration service creates the index and data cache files. We must link the Rank port to another transformation. Port we want to pass to other transformations.Ĭan use to store values or calculations to use in an expression. Port to receive data from another transformation. Set the if properties to calculate the ranks Variable port support to write expressions that are required for rank calculation. The port which is participated in a rank calculation is known as Rank port.Ī port that allows you to develop expression to store the data temporarily for rank calculation is known as a variable port. Input port (I) Output port (O) Variable port (V) Rank Port (R) The rank transformation is created with the following types of ports. However, the rank transformation allows groups of records to be ranked instead of a single value or record. One might think MAX and MIN functions can accomplish this same task. While string value ports can be ranked, the Informatica Rank Transformation is most commonly used to rank numeric port values. The Rank Transformation in Informatica is an active, connected transformation used to select a bottom or top range of data.
0 Comments
Leave a Reply. |