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 ...
Get Oracle GoldenGate 11g Complete Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
