Data Selection and Filtering in Oracle GoldenGate 12c

Share via:

Dear Readers,

In this article we will seeData Selection and Filtering in Oracle GoldenGate 12c.

 We care for your speed. Below is an easy way to perform   Data Selection & Filtering in Oracle GoldenGate 12c.

We can perform Data selection or Filtering in GoldenGate in two  ways.

They are :

  1. Where Clause
  2. Filter Clause

Where Clause :

Where clause is the simplest form of selection

WHERE clause appears on either the MAP or TABLE parameter and must be surrounded by parenthesis.

Oracle GoldenGate data selection is conceptually similar to the where clause found on SQL. The purpose is to limit data replication to a specific criteria. The selection can be developed as part of the primary extract, data pump extract or replicate process.

 

Example :

On Source :

Check table which to be replicat

Login into GGSCI prompt

Check GG processes

 

Edit extarct param file  and add WHERE clause with condition

Here i have added WHERE clause in the TABLE .

Now stop EXTINT and START it again

 

Check stats for extint

Insert records into dept table

Note :  I have inserted three records but Extract will allow only loc=’US’ values only

Check stats for EXTINT

Check stats for DPINT

TARGET :

On GGSCI check replicat stats

Check records available in  target table DEPT

 

Check records in Target table DEPT

 

Deptno 70 row  has been ignored by extract process because of loc is not equal to US

We can check using report file of EXTINT

What we cant do with selection-where clause 

  • Perform arithmetic operations
  • Refer to trail header and user token values
  • You can use the filter clause for more complex selections with built-in functions

 

Check Filtering for below link

 

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