Regarding source based CDC

[venkataramana_paidi]

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.

[former_member208402]

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.