Mapping a single source table using standard replication

You can use a wizard to map a single source table to a single target table.

1. Click Configuration > Subscriptions.
2. Select a subscription, right-click and select Map Tables.
3. Select Custom Table Mapping > Standard and click Next.
4. Expand the database, schema, or table from the Source Tables list to view tables from your database that are available for mapping. Right-click the database user or schema and click Refresh if you do not see your table listed.

   You may be prompted to filter databases, schemas, or tables if Automatically prompt for filter when expanding nodes is enabled in your preferences. For more information see, Setting advanced preferences. To manually define a filter, select a datastore, database, or schema and click Specify Filter.

5. Enable the table to map from the Source Table list. If you do not see your table listed, right-click the database user or schema and select Refresh.
6. If you want to hide columns so that the target is not aware of them, select a source table and click Filter Columns. Clear the check box for the column you want to hide and click OK.
7. Click Next.
8. Expand the database, schema, or table from the Target Tables list to view tables from your database that are available for mapping. Right-click the database user or schema and click Refresh if you do not see your table listed.
   If you want to create a new table to map to, click Create Table. CDC Replication will create a table that is generally able to hold the data being sent from the source but none of the other table characteristics, such as storage options, will be specified. The tables created by CDC Replication can often be useful for quickly creating test environments. For production environments a DBA should manually create a table that will better address the expected usage of the target system. Some source data types will have no natural corresponding target data type and CDC Replication will be unable to provide a default mapping. In these cases, you will need to explicitly create the target table.

   Note: The Create Table function is unavailable for the CDC Replication Engine for FlexRep
9. Choose one of the following and click Next:

   Use an Index

   Select the index (or constraint if you are mapping to target columns on a Netezza® database where the CDC Replication Engine for Netezza Technology has been installed) name from the box or select <Auto Detect> if you want CDC Replication to automatically choose the index or constraint. Use if your target table has an index or a constraint that uniquely identifies a row.

   Use all searchable columns

   Searches all target columns to identify which columns are suitable to uniquely identify rows. The results of the search are used to build a WHERE clause which uniquely identifies the row on the target column to apply data.

   Specify the key

   Select the target columns from the Key Columns list. Use if one or more target columns uniquely identifies a row.

10. Choose a replication method from the following and click Next:

    Mirror (Change Data Capture)

    Immediately replicates changes made to the source table to the target table or accumulate source table changes and replicate at a later time. If your configuration requires you to prevent recursive updates when mirroring, enable the Prevent Recursion check box. This check box is only available in components of CDC Replication that support both source and target databases.

    Refresh (Snapshot)

    Replicates a snapshot of the source table to the target table.

11. If you are replicating source database changes using the CDC Replication Engine for Oracle databases (trigger) and want to use a journal table to mirror database operations from the source to the target table, then enable one of the following:

    Use Default Journal

    Enable when you want the CDC Replication Engine for Oracle databases to use the default journal table provided with the CDC Replication Engine for Oracle databases: <TS SCHEMA>.DMCJRN. CDC Replication uses this journal table to detect and replicate database changes from the source to the target.

    Use Selected Journal

    Enable when you want the CDC Replication Engine for Oracle databases to use another journal table other than the default journal table provided with CDC Replication Engine for Oracle databases. When you select the database owner and provide a name for the journal table, the CDC Replication Engine for Oracle databases creates this new journal table and uses it to detect and replicate database changes from the source to the target.

    Owner

    Lists the database owner of the journal table.

    Name

    Lists the name of the journal table.

12. Click Next.
13. Review the mapping summary.
14. Choose one of the following options and click Finish:

    Define column mappings

    Continues with the column mapping.

    Create a new table mapping

    Allows you to start a new table mapping.

    Return to current view

    Returns you to the current view.