Chapter 4. Mapping and Manipulating Data

The following recipes will be covered in this chapter:

• Setting up a GoldenGate replication with mapping between different columns

• Adding custom fields for a replicated record using tokens

• Adding custom fields to a replicated record using SQLEXEC

• Filtering the records using the FILTER and WHERE clause

• Mapping the changes to a target table and storing the transaction history in a history table

• Creating a GoldenGate configuration to run a Shell script when an end-of-day processing record is replicated

• Creating an exception handler to record the erroneous transactions in a GoldenGate configuration