Column Mapping Configuration

To view and configure column mappings, use the Edit Column Mapping page.

Note:

You must create a compare pair before you can do column mapping. See Existing Compare Pairs.

The top of the Edit Column Mapping page displays column information about the objects that you are working with. It shows:

To View an Existing Column Mapping

Use the Existing Column Mapping tab to view the current mappings for the key columns and the comparison columns, and which method is being used to map them. This tab also shows the source and target columns that were excluded from being mapped, either explicitly by a user or because Oracle GoldenGate Veridata could not find a corresponding column with the same name.

To Test the Validity of the Current Mapping

It is possible for object metadata to change from the time that a column mapping was created to the time that you view it on the Existing Column Mapping tab. To confirm that the mapping is still valid, click Validate Column Mapping.

See Validating Column Mappings.

To Create or Change a Column Mapping

Use the Column Mapping tab to create or change a column mapping.

You must have the Administrator or Power User role to create or edit column mappings.

Validating Column Mappings

Validation is a preliminary test to determine whether or not the source and target table structures are compatible, and that they both have primary or unique key columns that match. You can perform a manual validation at any time. Oracle GoldenGate Veridata always performs a validation at runtime.

The following are possible validation statuses.

Icon Description

Gray question mark

Status is unknown.

Green check mark

The pair passed the validation criteria, and a comparison can be run.

Yellow exclamation point

No matching key could be found.

Red exclamation point

Column names do not match.

Gray exclamation point

Column names match, but data types are incompatible.

Blue exclamation point

Unknown failure.

To Perform the Validation

Click Validate Column Mapping on the Existing Compare Pairs tab of the Compare Pair Configuration page. Make certain to place a check mark in the Select column for all of the pairs that you want to validate. The result is displayed under Validation Status.

You can also perform validation when you are configuring column mapping on the Column Mapping Configuration page. On the Compare Pair Configuration page, click Edit in the Column Mapping column.

Related Topics

"Validating Column Mappings" in Oracle GoldenGate Veridata .