COLS & COLSEXCEPT FILTER In Goldengate

COLS & COLSEXCEPT FILTER In Goldengate

In this article we will see how to replicate only particular columns to the target table

On Source database :

Take Dept table and add two more columns

Now on source dept have 5 columns(DEPTNO,DNAME,LOC,MOBILE,PIN)

On Target database we should add same two columns if DDL is not enabled.

On Target database :

Now We will replicate only DEPTNO,DNMAE,LOC column values to the target

That means we need exclude MOBILE and PIN Column values

On Source GGSCI:

Connect to ggsci

Check process

Stop the extint process

Edit the param extint file

Add TABLE ajay.DEPT COLSEXCEPT(MOBILE,PIN);

Or

we can use COLS keyword to specify what columns to replicate.

Start the extint process

Now we can insert records into table on Source database.

Insert records

 

On Target :

Check records

Yes it replicate only first three columns.

 

Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

Add Comment