Skip to Content

Regarding source based CDC

Hi ,

We are going to implement source based CDC on oracle.

Actually we hjave source then we are moving data to staging area that is on SAP IQ. Then we are moving to DW layer.

If we are implementing CDC , are we going to apply directly on DW layer or on Staging layer?

In the DW layer, we are going to implement SCD type 2 & Type 1 flows.

Can I load from oracle to DW layer directly. If we are going to load to STG then how we are going to handle in the DW?

Thanks & Regards,

Ramana.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 26 at 10:23 AM

    As your source is Oracle, create source based CDC on source tables itselft. Everyday you can load only load changed/new records to staging. And your staging tables would be storing only changed/new records daily if your staging is truncate and reload, and you can load these records to DWH.

    Add comment
    10|10000 characters needed characters exceeded