Use of the Aggregator transformation (with sorted input condition enabled) followed by a Sorter transformation is quite common.
However, when user wants to introduce multiple partitions with this combination, data integrity is the main concern.
This video, demonstrates guidelines on
- how to use the partition and partition points to ensure that data integrity.
- And why the manual configuration change is required in this combination of transformations.
How to unassign services from an expired key and assign them to a valid key in 9.1.0 and 9.5.1
How to find in which host the Repository Integration service is running in a multi node domain
How to automate the repository and domain back up process for disaster recovery in PowerCenter