The "Pairing Type" step of the wizard allows you to specify the pairing method between tables and views.
Before data can be compared, tables (and views if needed) must be paired with one another, that is an EMPLOYEES table on the source schema must have the same EMPLOYEES table on the target schema to compare with. There are two ways to pair the Oracle objects:
- The default pairing - Tables are paired together by name. This is the default pairing method.
- The manual pairing - Tables, that should be compared with one another, must be paired manually. This method is suitable when you wish to compare tables have different names.
The default pairing is the recommended method. In the data compare UI, this is the method used when two Oracle schemas are compared. You can use the manual pairing when tables that should be compared do not have the same names. In the data compare UI, this method is used when specific tables are compared.
The manual pairing sets the following option in the xml config file:
<CommandLineOptions>
**** ****
<MappingType>Custom</MappingType>
</CommandLineOptions>