Consolidation Transformation
Effective in version 9.5.1, the Consolidation transformation uses data from the record with the highest row ID by default when it creates a consolidated record.
Previously, the transformation used the most frequent non-blank data values in each column by default to create a consolidated record.
When you upgrade a repository that contains a Consolidation transformation configured with the default settings, the transformation continues to use the most frequent non-blank option. The transformation maintains the most frequent non-blank option when you upgrade a Model repository or a PowerCenter repository.
If you import a mapping to PowerCenter that contains a Consolidation transformation that uses the default 9.5.1 settings, the transformation uses the highest row ID to identify the consolidated record.