O'Reilly logo

Oracle GoldenGate 11g Implementer's guide by John P Jeffries

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

Data selection and filtering

In addition to column mapping, GoldenGate offers two data filtering options:

  • Complex
  • Non-complex

Non-complex filtering is achieved through the WHERE clause in a TABLE (Extract) or MAP (Replicat) statement, while complex data evaluations use the FILTER clause. FILTER can select rows and columns for a given operation, whereas WHERE just selects rows. FILTER can also use GoldenGate built-in functions.

The Extract and Replicat parameter files can be modified without stopping the process. However, care should be taken to avoid syntax errors causing the process to abend. Remember that once saved, the new configuration in the parameter file is adopted immediately by the running process.

The WHERE clause

Configuring a WHERE clause ...

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