Skip to Content

Regarding source based CDC

Feb 26 at 08:57 AM


avatar image

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,


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ravi kiran Pagidi 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.

10 |10000 characters needed characters left characters exceeded