| Sorter is a active transformation and connected . |
| Sorts data based on a sort key.You can sort data in ascending or descending order according to a specified sort key |
| |
| Sorter Cache Size |
|
| Case Sensitive |
- When you enable the Case Sensitive property, the PowerCenter Server sorts uppercase characters higher than lowercase characters
|
| |
| Work Directory |
- You must specify a work directory the PowerCenter Server uses to create temporary files while it sorts data
|
| |
| Distinct Output Rows |
- It gives distinct output rows .It discards all the duplicate rows .
|
| |
| Null Treated Low |
- Enable this property if you want the PowerCenter Server to treat null values as lower than any other value when it performs the sort operation
|
