-
Book Overview & Buying
-
Table Of Contents
Oracle GoldenGate 11g Implementer's guide
By :
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.
Configuring a WHERE clause is much like the WHERE clause in an SQL statement. In this case we add it at the end of the TABLE or MAP statement. The following example will filter out from the source trail, those records that have an amount greater than 1000 in the CREDITCARD_PAYMENTS...
Change the font size
Change margin width
Change background colour