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.
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