My Oracle Support Banner

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

Last updated on JANUARY 22, 2020

Applies to:

Oracle GoldenGate - Version and later
Information in this document applies to any platform.


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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.