Open the Compare Request Editor
Use the Compare Request Editor to create or modify a Compare Request. Specify the parameters needed to run the Compare Process including the name of a Compare File to record the results of the data comparison, the Comparison Mode (Single Table or Multiple Tables), and the explicit sources of data to compare.
In Single Table mode, you can compare the data in one table to another. The source data can be contained in an existing Source File (Extract or Archive File) or extracted from a database table. You can use an optional Column Map to compare columns with unlike names or to exclude specific columns from the comparison.
In Multiple Tables mode, you can compare two sets of data in related tables. The source data can be contained in an existing Source File (Extract or Archive File) or extracted from a database using an Access Definition. A Table Map is required to match the tables to compare, correlating tables with unlike names, or selectively excluding tables from the comparison. You can reference optional Column Maps in the Table Map to compare columns with unlike names or to exclude specific columns from the comparison.
There are different ways to open the Compare Request Editor, depending on whether you want to create a new Compare Request or use an existing Compare Request.