Hi Guys,
I am newer in ODI 12C, I installed ODI 12 (12.2.1.2.0) last week, and perform a full-integate from oracle (source) to Postgresql (target) successed.
Then I wan trying create a incremental integrating also with the 2 Database.
First, I add a Primary key into the source table (Oracle) in ODI (not in database);
Next, add above table into CDC, and book the farther Model for user "SUPERVISOR", Then I found a green clock in the source table. (See below picture 01)
Third, reverse the target table (PostgreSQL) in another Model, this table have same stucture with source Oracle table, and I have defined the Primary key in Postgresql;
Fourth, create a new mapping in a new project, drag the Oracle table into Source Area, and Postgres table into target area, perform auto mapping as they are same structure.
Fiveth, click target table in Logical page, set integration type as "Incremental Update" (See picture 02);
Sixth, click source table is Physical page, check the Journalized Data Only. And select "XKM Oracle Extract Global"(See picture 03 , 04);
Seventh, LKM set "LKM SQL TO SQL" , IKM IS " IKM SQL Incremental Update" (See picture 05 , 06);
After complete above actions, I saved the Mapping and run it, here occured the ERROR:
"Exception when invoking: SELECT method in AST processor source for component KM XKM Oracle Extract when generating source for node : PEREMPMS_1" (See picture 07);
