ODI CDC

Process: Simple CDC
1.     Create source and target datastores
a.     Create database tables
b.     Create Physical Architecture
c.      Create Logical Architecture
d.     Create Model
e.     Reverse Engineer the datastores
2.     Import knowledge module à JKM Oracle Simple
3.     Open Model and navigate to Journalizing and then select Journalizing mode as “simple” and select above imported knowledge module
4.     Now, we need to select which datastore we are going to perform CDC
5.     Right click on datastore à Change Data Capture à “Add to CDC” and click “Yes”
6.     Right click on datastore à Change Data Capture à “Subscriber”à “Subscriber” à Provide subscriber name and click on “plus” symbol
[Note: Datastore should have primary key then only we can apply journalization]
7.     Right click on datastore à Change Data Capture à Start Journal and select appropriate subscriber for your process
8.     Now, create an interface in the project
9.     Drag and drop datastores into interface in appropriate location
10.  Select “Source Datastore” and go to property inspector, there we need to enable “Journalized Data Only” then it will create one filter on source datastore
11. Select that filter and modify the subscriber according to name you provide in your previous step and save it
12. Go to flow and select appropriate knowledge module (i.e., IKM Oracle incremental Update)