How to use Change Data Capture in Oracle (Step 2/4)
Learn how to implement a Change Data Capture (CDC) in Oracle
In this tutorial, you will learn how to design a Job to generate the data representing the customers (ID, Name, Forename, Age) and to simultaneous load the data into the DATA and DWH databases to simulate the data synchronization.
The tcdc_customers table has been created in the Oracle database. It contains four columns, plus the column which represent the primary key.
- TALEND_CDC_SUSCRIBERS_NAME represents the DWH_Customers subscriber that you just created. - TALEND_CDC_STATE is set to "0" if the modification has been consumed by the subscriber, and "1" if not. - TALEND_CDC_TYPE represents the type of modification that has been carried out: "I" for Insert, "U" for Update, "D" for Delete. - TALEND_CDC_CREATION_DATE represents the date of the modification. - ID represents the data which has been modified, and is identified by its primary key.