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.
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 ...