Master Note for Oracle GoldenGate for Filtering and Transformation Data
(Doc ID 1450495.1)
Last updated on MARCH 12, 2021
Middleware > Data Integration > GoldenGate Information in this document applies to any platform.
This note provides background and troubleshooting information applicable to Oracle GoldenGate data transformation. Its main purpose as a master note is to bring together reference material in a form which allows a clear understanding of what is required in the configuration as well as to where to look when there are issues. Its focus is setup and understanding relevant parameters setting which are required to integrate data between source and target tables to obtain the format required by target tables and applications. It will include: differences in table names and column names, differences in table definitions, data transformation and data differences. The samples are based on Oracle Server database but apply to all databases where Oracle GoldenGate is certified.
This document is intended for anyone with an interest in understanding data and column transformation and mapping. Where samples are provided for reference to DBAs and Application developers. It is likely these will require modification in view of the fact that the examples presented are for illustration purposes. In order to have a better insight into how the examples work, please ensure you have read and understood the information below.
Whilst every care has been taken to ensure that the details are correct and accurate, code should be throroughly tested to verify it is fit for intended purpose.
Please note, the approach adopted in relation to knowledge has been to improve Oracle's product documentation. Thus, relevant content in relation to data transformation is now found in the primary references guides for Oracle GoldenGate; if possible, please refer to the lastest documentation documentation library specific to your platform and database, eg:
Oracle® GoldenGate Windows and UNIX Administrator’s Guide
Oracle® GoldenGateOracle Installation and Setup Guide
Oracle® GoldenGate Windows and UNIX Reference Guide
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!