Mapping Columns on Oracle GoldenGate 12c

Share via:

Dear Readers,

In this article we will see Mapping Columns on Oracle GoldenGate 12c.

We care for your speed. Below is an easy way to  Mapping Columns on Oracle GoldenGate 12c

Oracle GoldenGate provides for column mapping at the table level and at the global level. Default column mapping is also provided in the absence of explicit column mapping rules.

Configuring Table-level Column Mapping with COLMAP

Use the  COLMAP option of the MAP and TABLE  parameters to :

 Note :

1.Configure GG setup between Source and Target

2. Make sure Extract ,Datapump process running on Source and Replicat on Target

Node Details :

GG1 (SOURCE)

192.168.0.120   gg1.orcl.com   gg1

Database Name :orcl

Instance Name : orcl

GG2(TARGET)

192.168.0.180   gg2.orcl.com   gg2

Database Name :orcl

Instance Name : orcl

Let’s start  the Scenario

SOURCE :

Create  table on AJAY schema

TARGET :

Create test10 table with different structure

SOURCE :

Edit  extract (EXTINT) param file  and include TABLE AJAY.TEST10;

Check datapump(DPINT) param file

TARGET :

Edit Repilcat(REPINT) param file

SOURCE :

Insert a record into test10 table

TARGET :

Check replicat process (It should be abended because of column mismatch)

Check report file for  errors

In Source column name is MOBILE and the target column name is CELL

Replicat process not able to write the data into target database  due to column mismatch.

Specifying the Columns to be Mapped in the COLMAP Clause

The COLMAP syntax is the following:

Edit the repint file

Stop and Start the Replicat process

Check stats for repint

Check records in target table

The Replication is happening successfully !

ADD one  more column On source with different structure

SOURCE :

TARGET :

On Source column name is ADDRESS and on Target ADDR

Edit the repint and put multiple column

Stop and Start the Replicat process

SOURCE :

Insert records on test10 table

TARGET :

Check stats for  repint

Now check records on target table

Replication happening successfully on two different column structure !

Thank you for giving your valuable time to read the above information. Please click here to subscribe for further updates

KTEXPERTS is always active on below social media platforms.

Facebook : https://www.facebook.com/ktexperts/
LinkedIn : https://www.linkedin.com/company/ktexperts/
Twitter : https://twitter.com/ktexpertsadmin
YouTube : https://www.youtube.com/c/ktexperts

 

Share via:
Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)
Loading...

Add Comment