After clicking on Connect the Source Target window changes its appearance slightly. It displays a summary of the values of your source and target and displays new fields for your attention.
-
In the Source Type column from the Domain List selection box, select the domain name to be used in for the source.
This is available only if you have selected a database as your source.
-
In the Target Type column from the Domain List selection box, select the domain name to be compared against the source.
-
In the File Location field, do one of the following:
-
Type in the location of where you want the report file to be saved.
-
Click the Browse
button and navigate to the folder where you want the report file to be saved.
-
-
Select the File Type checkbox for the required report. You can choose CSV, Excel, or both.
We recommend opening this file in Excel to gain the benefit of all.Reference Data Comparison Utility features.
-
Click Compare.
The comparison starts and a progress bar is displayed at the bottom of the window.
Depending on the size of your source and target the comparison can take quite a few
hours before it is completed.