Oracle GoldenGate Data Transformation

Oracle GoldenGate Replication supports data transformation of data as it is read from the trail file and before it is put inside the database. This data mapping and manipulation is enabled by using the MAPPING parameter options.

Transformation of the data can be done in the EXTRACT or the REPLICAT process. Here we will see how configure the processes to perform a simple transformation on the REPLICAT side.

Oracle GoldenGate Transformations

Environment Details

Environment

SOURCE

TARGET

OGG Version

11.2.1.0.6

11.2.1.0.6

Oracle DB Version

11.2.0.3

11.2.0.3

Schema

SCOTT

SCOTT

Prepare SOURCE and TARGET Database
Create the tables below on the SOURCE and TARGET.

Enable Supplemental Logging
Oracle GoldenGate requires that you enable supplemental logging at the database level and all the tables that are part of replication. Verify and add the supplemental logging if it is not already enabled.
SQL> select supplemental_log_data_min from v$database;
SUPPLEME
--------
NO

Create DEFGEN File
Since SOURCE and TARGET table definitions are different we must create a SOURCE table definition file and copy it to TARGET server. In our Demo we are mapping the columns on the TARGET side.

Join over 3,000 others My posts. Your Inbox. Beautiful.

Database GoldenGate

About Natik Ameen

Natik Ameen is an Oracle Production DBA, Oracle Certified RAC Expert and a DBA track Certification trainer for over 17 years. He is an Oracle Evangelist and has presented at IOUG & UTOUG conferences. He writes on topics such as Database Administration, RAC, GoldenGate and the Cloud. Stay connected with Natik at LinkedIn or FaceBook.