Change data capture Screen
Change Data Capture
Changed Data Capture as the term implies is used to capture the data that
is inserted, updated and deleted at the source side and replicating the
same at the target.
- ODI have a Journalizing KM to do the required implementation and it is basically into two types simple and consistent.
- Simple is used for CDC implementation on a single table and Consistent on Multiple tables or Model.
- The purpose of CDC is allow applications to process changed data only.
2. Add the datas tores to the CDC
3. For consistent set journalizing, arrange the data stores in order
4. Add subscribers
5. Start the journals

needed tables
Import the JKM –here we using
JKM oracle Simple
Click on journalizing tab in the model, select simple
and KM JKM oracle simple. my_project
Step:1
Set up the CDC Infrastructure.
Right click on customer_cdc, and select Change data capture
A yellow clock icon is added in the table.
Step:2
Right click on the customer_cdc table change data capture start journal
Step 3
Step the default subscriber
sunopsis,- click on ok
Can see a green clock symbol in the customer_cdc table.The session will start
Step 4
Operatorall excecutions check the the customer_cdc is executed successfully.
Modelview data
Step 5:
Change any row, [
cust_id :101, cust_name ( XYZ)
Cust_id : 104 , phone_number 100
Deleted, last row
cust_id—201 ]
Step:6
To verify that your changed data is captured, right-click Customer_cdc,
and select Change Data Capture > Journal Data. Find the captured
changed records in the journal data.
Now the output is: