In addition to column mapping, GoldenGate offers two data filtering options:
Non-complex filtering is achieved through the
WHERE clause in a
TABLE (Extract) or
MAP (Replicat) statement, while complex data evaluations use the
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.
WHERE clause ...