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:
-
The name of the compare pair, its container group, and the underlying source and target objects.
-
The methods of mapping keys and comparison columns (see Column Mapping).
-
The status of column validation (see Validating Column Mappings).
-
Configure delta processing see (Controlling Delta Processing)
-
If an Enscribe database, current Expand DDL settings (under Datasource Information). See Expanding DDL Settings.
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.
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 |
---|---|
|
Status is unknown. |
|
The pair passed the validation criteria, and a comparison can be run. |
|
No matching key could be found. |
|
Column names do not match. |
|
Column names match, but data types are incompatible. |
|
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 .