 How to use Change Data Capture in Oracle (Step 2/4)
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.
42
|
