Is De-normalization Supported In GoldenGate?
(Doc ID 1194273.1)
Last updated on JULY 17, 2017
Oracle GoldenGate - Version: 10.4.0.99 and later [Release: 10.4.0 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!