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

Introduction

When GoldenGate is used in some of the topologies where the source and target systems are not identical, you ...

Get Oracle GoldenGate 11g Complete Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.