O'Reilly logo

Oracle GoldenGate 11g Complete Cookbook by Ankur Gupta

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Filtering the records using the FILTER and WHERE clause

One of the most powerful features of GoldenGate is the ability to replicate the data which can be chosen on the basis of built-in logic in its parameter files. There is a FILTER command using which this can be done. FILTER is a very versatile command, as you can define complex logic to select the data based on conditions.

In this recipe we will look at how you can use the FILTER command to select the records to be replicated by a Replicat process. We will also look at some examples of various filter conditions.

Getting ready

For this recipe, we will use the following CUST table. This table is created in the source and target databases under the SCOTT schema. There is an additional table in the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required