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 automate the repository and domain back up process for disaster recovery in PowerCenter
How to find in which host the Repository Integration service is running in a multi node domain