Technology Blogs

  Oracle Change Data Capture (CDC) is a feature of the Oracle database that detects and captures any changes made to the Oracle database including mentions, deletions, and updates. This technology is apart of the Oracle replication process. Oracle CDC identifies and notes changes made to data in the relational format that is suitable for use in applications such as ETL, EAI, and more. Further, Oracle Change Data Capture is a cost-effective solution for organizations as it extracts and loads data into the data warehouse or other data storage repositories in real-time. Hence, there is no need to refresh full data in bulk whenever any modifications are made at the source. There are two types of Oracle CDC. Each has different characteristics and businesses have to select one that matches their needs. ·         Synchronous Change Data Capture: It is done through triggers that are inserted into entries whenever data is modified in change table. These points are activated when any chan