The Mapping page dynamically loads both source and target tables for performing the mapping or unmapping operations. Automatic mapping requires you to select one or more source tables that are automatically mapped to the target tables. Whereas manual mapping requires the 1:1 linking between a single source table and a single target table. After manually mapping the tables, you can either manually or automatically map the source fields to the target fields.

  1. Source Database—Displays the name of the source database that will be replicated.
  2. Target Database—Displays the name of the target database to which the source database will be replicated.
    Note: Before you map any tables from source to target, specify the source and target databases. For more information on selecting the source database, see Select source, and on selecting the target database, see Select target.
  3. Auto Map—Opens the Auto Map Tables dialog box, displaying the list of unmapped source tables that can be automatically mapped to the target database tables. You can either search the tables or select one or more tables from the list. The application automatically maps the selected source tables to the matching target tables and creates field cross-reference records for any matching fields in those target tables. This is possible only for tables and fields that have a direct matching table name and field name in the corresponding target.
  4. Map Table Only—Opens the Map Tables dialog box, displaying the list of unmapped source tables that you can manually map to the target tables. You can either search the table or select a specific source table from the list to create a 1:1 mapping with the target table. This operation creates a table mapping record for source and target tables selected in the Unmapped Source Tables and Unmapped Target Tables panes, respectively.
    Note:
    • Map Table Only does not map source fields to target fields; it maps only the source table to the target table. To map the fields of the source tables to those of the target tables, click Auto Map Fields, Map Fields, or Field List on the Mapping page.
    • You can map only one source table at a time.
  5. Un-Map—Opens the Unmap Tables dialog box, displaying the list of mapped source tables that you can unmap. You can either search the tables you want to unmap or select one or more tables from the list. This operation removes the mappings for the selected tables and their fields.
  6. Table List—Opens the Enter Table List dialog box, in which you can enter a comma-separated list of source tables that can be either mapped (automatically) or unmapped. Click Auto Map to automatically map the source tables and their fields with the target tables and their fields, respectively. Click Un-Map to perform the unmap operation and remove the mappings.
  7. Mapped Tables—Displays the list of mapped source tables along with their respective target tables.
  8. Mapped Fields—Displays the following information about source table that is currently selected in the Mapped Tables pane:
    • Source Field—The source field that is mapped.
    • Source Data Type—The datatype of the source field.
    • Target Field—The target field to which the source field is mapped.
    • Target Data Type—The datatype of the target field.
    • Scale—The number of digits to the right of the decimal point in a numerical source field.
    • Precision—The length of the source field.
  9. Auto Map Fields—Opens the Auto Map Fields dialog box, displaying the list of unmapped source fields for the table that is currently selected in the Mapped Tables pane. These fields can be automatically mapped.
  10. Map Fields—Opens the Map Fields dialog box, displaying the list of unmapped source fields along with their datatype for the table that is currently selected in the Mapped Tables pane. You can manually map these fields with the respective target table fields.
  11. Un-map Fields—Opens the Unmap Fields dialog box, displaying the list of mapped source fields for the table that is currently selected in the Mapped Tables pane that can be unmapped.
  12. Field List—Opens the Enter Field List dialog box, in which you can enter a comma-separated list of source fields for the table that is currently selected in the Mapped Tables pane. These fields can be either mapped (automatically) or unmapped. Click Map Fields to automatically map the source table fields to the target table fields. Click Un-Map Fields to perform the unmap operation and remove the mappings.