| Rank transforation is a active transformation. |
| The Rank transformation allows you to select only the top or bottom rank of data |
| During the session, the PowerCenter Server caches input data until it can perform the rank calculations. |
| |
| Rank Properties:: |
| |
| Data Movement :: |
-
When the PowerCenter Server runs in the ASCII data movement mode, it sorts session data using a binary sort order.
-
When the PowerCenter Server runs in Unicode data movement mode, the PowerCenter Server uses the sort order configured for the session.
|
| |
| Case-Sensitive String Comparison :: |
-
If the session sort order is case-sensitive, select this option to enable case-sensitive string comparisons, and clear this option to have the PowerCenter Server ignore case for strings. If the sort order is not case-sensitive, the PowerCenter Server ignores this setting. By default, this option is selected.
|
| ** Note ::If you dont check the option case sensitive string :: first preference goes to lower case and vice versa. |
| |
| CACHE :: |
-
Data cache size for the transformation. Default is 2,000,000 bytes.
-
Index cache size for the transformation . Default is 1,000,000 bytes.
-
If the total configured session cache size is 2 GB (2,147,483,648 bytes) or more, you must run the session on a 64-bit PowerCenter Server.
|
| |
| Rank Index :: |
| |
| The Designer automatically creates a RANKINDEX port for each Rank transformation. The PowerCenter Server uses the Rank Index port to store the ranking position for each row in a group |
| |
