COLS & COLSEXCEPT FILTER In Goldengate

Share via:

Dear Readers,

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.

 

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 (1 votes, average: 5.00 out of 5)
Loading...

Add Comment