Table Mappings view

After defining a subscription in Management Console, you can use the Map Tables wizard to map source and target tables. Subscriptions can contain as many table mappings as necessary, and the number of table mappings you create depends on how many source tables you want CDC Replication to replicate to the target system. The table mappings that you create with the wizard are displayed in this view, and when you select a subscription with table mappings, the table mappings are loaded into the view.

Use the Table Mappings view to see a list of mapped source and target tables within a subscription. You can also view the mapping type, replication method, status, and prevent recursion parameter of each table mapping.

In this view, you can perform the following actions:

View a list of mapped source and target tables within a subscription
View a list of defined rule sets for use with DDL replication
View the mapping type, replication method, status, and prevent recursion parameter of each table mapping
Change the replication method of a table mapping
Flag a source table for refresh before mirroring
Mark a table capture point on a source table
Park a table mapping from replication
Change the refresh order on a table mapping
Customize the kind of information you want to map to target columns in a subscription.
Include or exclude rows or columns for replication.
Add, modify, and delete a data translation.
Specify how CDC Replication converts character sets on source and target columns during replication.
Set how a target table responds to changes made on the source table.
Control the truncation of the target table in response to a table-level clear or refresh operation so that all or some of the rows are preserved.
Set member identifiers for multi-member source tables.
Configure conflict detection and resolution.
Configure user exits.

If you are mapping tables with both the source and target datastores of the CDC Replication Engine for Oracle databases version 6.5.1 or later, you are able to replicate DDL changes. The Table Mappings view will then have two displays: Direct Mappings and Rules. The Direct Mappings display will show the mappings created using the Map Tables wizard. The Rules display will show all rule sets defined for the selected subscription. For more information on replicating DDL changes and defining rule sets, see Replicating Data Definition Language (DDL) changes

At the bottom of the Table Mappings view, the Details area will display information about either the selected table mapping or selected rule. This information can be viewed by double-clicking on either the table mapping or the rule set name.

If a rule set has been selected, the Details area will display the details of the rule set.

If a table mapping has been selected, a number of tabs containing mapping information details are available. The specific tabs that are loaded for display will differ depending on which databases and which version of corresponding CDC Replication agents on the source and target systems for the selected table mapping. The following list contains descriptions for each of these tabs:

If you have been viewing multiple table mappings or rule sets, you can use the Recent Mappings list box to return to a previously selected item.

Column Mappings

Use this tab to perform the following tasks:

map source columns to target columns
create a derived column on the source table
build custom expressions and map to target columns
map accumulation and deduction expressions for summarization mapping types
map journal control fields
map source and target columns automatically
set initial values for target columns

Filtering

Use this tab to perform the following tasks:

define a row-filtering expression to include or exclude rows from replication
filter columns
enable critical column selection

Translation

Use this tab in CDC Replication version 6.3, and earlier, to perform the following tasks:

set data translations

Encoding

Use this tab in CDC Replication version 6.5, and later, to perform the following tasks:

set encodings
set encoding conversions
set multibyte character encoding conversions (this is a new feature and only available in specific platforms and versions of CDC Replication)

Conflicts

Use this tab when you want CDC Replication to detect conflicts on target columns and resolve them:

source row wins
target row wins
largest value wins
smallest value wins
user exits

Operations

Use this tab to specify the row-level or table-level operations you want CDC Replication to apply on a target table when there is a corresponding row-level or table-level operation on the source table.

If you do not want CDC Replication to detect conflicts on target columns, then you can select None.

User Exits

Use this tab when you want CDC Replication to detect conflicts on target columns and resolve them. You can perform the following tasks:

identify the name and type of user exit you want CDC Replication to call
specify at which event or action you want CDC Replication to call the user exit (either before or after a row-level or table-level operation)

Flat File

Appears if you have an InfoSphere® DataStage® subscription that was created using the flat file method. It includes the following information:

Location: Specifies the location of the directory for output of the flat files.
Record Format: Specifies the format of the records to be generated.
Custom Data Format: Specifies the name of the Java™ class used, if any, to format the data.

Direct Connect

Appears if you have an InfoSphere DataStage subscription that was created using the direct connect method. It includes the following information:

Record Format: Specifies the format of the records to be generated.

Cloudant

Appears if you have a subscription containing table mappings for Cloudant®. It includes the following information:

Cloudant Database: Specifies the Cloudant database to which source changes are sent.
Primary Key: Specifies the key for querying the Cloudant database for an existing document.
Parent Table: Specifies the parent table for compound documents.

Web HDFS

Appears if you have a subscription containing table mappings for Apache Hadoop using the Web HDFS. It includes the following information:

Web HDFS Directory: Specifies the directory on the Web HDFS server for output.
Record Format: Specifies the format for the records to be generated.
Custom Data Format: Specifies the name of the Java class used, if any, to format the data.