In addition to column mapping, GoldenGate offers two data filtering options:
FILTERcan select rows and columns for a given operation, whereas
WHEREjust selects rows.
FILTERcan also use GoldenGate's built-in functions.
WHEREclause in a
As a rule of thumb, it is best practice to adopt the following strategy to avoid any performance overhead associated with data selection and filtering: