Skip to main content

Posts Tagged ‘change data capture’

Oracle Data Integrator (ODI) – Logical or “soft” deletes

Logical deletes are a common practice when loading dimensions in a data warehouse. If a dimensional record is deleted in the source database, it may need to continue to exist in your data warehouse. In my recent project, this was one of the requirements set during the design phase. Since ODI was being used as […]

Change Data Capture: Capabilities, UseCases and Offerings: Part 2

The post is the 2nd in the series which covers capabilities, use cases and product offerings for change data capture technology. The critical capabilities which are expected in a CDC tool Selective data replication and synchronization is a capability to synchronize data between multiple databases. It usually supports high volume and mission critical scenarios. An […]

Change Data Capture – It’s all about timing !!

A few weeks ago, I got a gmail chat message from a friend telling me that my favorite sports team was having a great match and that i should definitely watch the match.  So I went to the sports portal to get the latest score and see what the team was doing. I found that […]