Rank is an active transformation which is used to assign the ranks on input data. The integration service caches the input data and then perform calculations.
Creating Rank Transformation
In the mapping dessigner->Mpping->Create new mapping
Go to Transformation->Select Rank Transformation->Specify Name->Create->done.
Select the ports from previous transformation and drag them in to the Rank transformation.
Edit Rank Transformation-> Configure it
Configuring Rank Transformation
Cache Directory: Cache directory is where the integration service creates data and index cache files.
Top/Bottom: Specifying top or bottom rank of the data.
Number of Ranks: Specifying how many ranks we want.
Case Sensitive String Comparison: Sorting the strings case sensitive or not.
Rank Data Cache Size: The data cache size is 2,000,000 bytes. The integration service determines the cache size at run time.
Rank Index Cache Size: The index cache size is 1,000,000 bytes. The integration service determines the cache size at run time.
Creating Rank Transformation
In the mapping dessigner->Mpping->Create new mapping
Go to Transformation->Select Rank Transformation->Specify Name->Create->done.
Select the ports from previous transformation and drag them in to the Rank transformation.
Edit Rank Transformation-> Configure it
Configuring Rank Transformation
Cache Directory: Cache directory is where the integration service creates data and index cache files.
Top/Bottom: Specifying top or bottom rank of the data.
Number of Ranks: Specifying how many ranks we want.
Case Sensitive String Comparison: Sorting the strings case sensitive or not.
Rank Data Cache Size: The data cache size is 2,000,000 bytes. The integration service determines the cache size at run time.
Rank Index Cache Size: The index cache size is 1,000,000 bytes. The integration service determines the cache size at run time.
Difference between Rank and Dense Rank:
Both Rank and Dense Rank will assign the ranks but dense rank will assign the consecutive ranks.
Cycle
It will repeat the sequence numbers between start and end values.
Reset
It will start from the current value.
Implementing Rank Transformation
- Drag source and target from repository to designer
- Go to Transformation->Create->Rank->OK
- Copy all the ports from source qualifier to Rank.
- Edit->rank->Ports->select SAL as rank
- Properties->Top(Here we select Top/Bottom)
- Properties->no of ranks=5(We mention our choice)
- Connect all the ports from rank to target.
