Informatica PowerCenter allows you to compare objects present within a repository. You can compare sources, targets, transformations, Mapplets, and mappings in PowerCenter Designer under Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer, and Mapping Designer respectively. You can compare objects in the same repository or in multiple repositories.
Follow these steps to compare two objects. We are using two sources to compare as an example.
- In the Designer, go to
Tools
|Source Analyzer
|Sources
|Compare
, as shown in the following screenshot: - Select
Source 1
andSource 2
that you wish to compare, as shown in the following screenshot: - Click on
Compare
. - You can check different types of comparison options for the two sources. Informatica PowerCenter Comparison Utility gives the option to check differences in the repository and versions under the General tab. The Table tab allows you to check differences in the owner name and database type. The Column tab...