Oracle GoldenGate Best Practices: Creating History Tables

Introduction

Oracle GoldenGate’’s flexible architecture provides built-in functionality for the transformation of captured transactional data. This data manipulation may take place anywhere in the Oracle GoldenGate stream; but is most commonly performed in the Change Data Apply (Replicat) process during data apply to the target.

Main Article

In this document we shall use this functionality to build (1) a classic operation history table where all activity is recorder, and (2) a history table that records only data modifications.

It is assumed that the reader has knowledge of the Oracle GoldenGate application, including how to install and configure the product; therefore, this information is not presented.

The complete document can be found on the Oracle Support site under the document ID:1314698.1

Add Your Comment