In this section, we'll go over some advanced settings you could apply such as filtering, mapping, and data transformation.
OGG, in addition to replicating, allows data filtering, mapping, extraction, and transformation. Following, you'll discover a number of other functions that OGG can perform at either the source host or target host.
TABLE SCOTT.* ;
tableexcludeclause as follows:
TABLEEXLCUDE SCOTT.EMP ; TABLE SCOTT.* ;
… IGNOREDELETES MAP SCOTT.* , TARGET SCOTT.* ...