Is De-normalization Supported In GoldenGate? (Doc ID 1194273.1)

Last updated on JULY 17, 2017

Applies to:

Oracle GoldenGate - Version: 10.4.0.99 and later   [Release: 10.4.0 and later ]
Information in this document applies to any platform.

Goal

We have 2 tables (Parent and Child table) in source having one to one OR one to zero relationship ( For each record in parent, there is one or zero record in Child table). Can we use Golden Gate to maintain one denormalized table on Target? Right now we are using Materialized view on target to join 2 tables on source and get the data in denormalized materialized view on target.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms