To set the Mapping Rules for the Groups and Compare Pairs:

1. In the Mapping Rules section, select one of the following methods for matching source table names to target table names. By default, Mapping Rules is toggled.
   • Using Exact Names

     This pattern matches names character-for-character, so ensure that each source and target name are identical. As an example, this mapping rule is useful for comparing production and failover databases. By, default the Using Exact Names option is selected. Select Using Exact Names if you want to map the tables defined at database. For example, if there are 10 partitions in Source Table matching 10 table partitions in Target Table with same table names, then 10 compare pairs are created. If no table exists then, one compare-pair per table gets generated. After all partitions are mapped, details of compare-pairs generated are displayed in Preview Tab.

   • Using Wildcard Pattern. (Enclose within single % on either side)

     To use this method, supply a wildcard string in Source Pattern and Target Pattern Like, and select either Like or Not Like options (for both Source Pattern as well as Target Pattern) that include the percent symbol (%) as the wildcard. A % in the target matches the text that is matched by the % in the source. By default, the Like option is selected for both the source and target tables. You can select Not Like if needed during the compare-pair generation.

     • Example:

       Assume source tables of:

       SOURCE_TABLE_1
       SOURCE_TABLE_2
       MY_SOURCE_TABLE_1
       MY_SOURCE_TABLE_2
       DUMMY_TABLE

       Assume target tables of:

       TARGET_TABLE_1
       TARGET_TABLE_2
       MY_TARGET_TABLE_1
       MY_TARGET_TABLE_2
       DUMMY_TABLE
       MY_DUMMY_TABLE

       Some possible Like pattern matches are:

       Table 5-1 Examples for Mapping Rules Using Wild Card Option % - Like option selected

       Source Pattern	Target Pattern	Matches
       %SOURCE_%	%TARGET_%	SOURCE_TABLE1=TARGET_TABLE1, SOURCE_TABLE2=TARGET_TABLE2
       %MY_SOURCE_%	%MY_TARGET_%	MY_SOURCE_TABLE1=MY_TARGET_TABLE1, MY_SOURCE_TABLE2=MYTARGET_TABLE2
       %SOURCE_%	%MY_TARGET_%	Table1=Table2 TABLE2=TABLE2
       %DUMMY_TABLE%	%_TABLE%	DUMMY_TABLE=DUMMY_TABLE
       %DUMMY_TABLE%	TARGET_%_	None

       Table 5-2 Examples for Mapping Rules Using Wild Card Option % - Not Like option selected

       Source Pattern	Target Pattern	Matches
       %SOURCE_%	%TARGET_%	DUMMY_TABLE=DUMMY_TABLE

     • The wildcard resolution is case-sensitive.

   • Include Views: The Include Views check box is selected by default. In the Mapping page, you can select the compare pairs based on the Mapping rules. This also has the View Table pair if you include views in the mapping rules page. Mapping rules are ways to ease mapping or to automatically create mapping between source and target database based on selected rules. If you do not want to include Views, then you can deselect the check box.

   • Include Table Partitions: The Include Table Partitions check box is selected by default. This option allows you to include all the table partitions (when applicable to the database) while generating compare pairs. If you do not want to include table partitions, then you can deselect the check box.

2. After you have selected the Mapping Rules, click Next to display the Mapping section.

By default, the Mapping section shows all of the source and target objects that are contained by the specified datasources. You can filter the list at any time in the process of creating compare pairs. For example, after you finish mapping several compare pairs, it might be helpful to reduce the size of the list by using the filter to show only unmapped objects. This saves you navigation time.

• Automatic Row Partition
  If you want to split the large table comparison into multiple partitions, then you can use Automatic Row Partition. The partitioning is possible only when both the source database and target database are Oracle.

You can view compare pairs that can be generated by using the mapping in the Preview section. You can select the compare pairs in the Preview page. Based on the selection, you can generate the compare pairs.