This content has been marked as final. Show 4 replies
ODI need a primary key to run the CDC...
Can you create a logical PK in your Datastore only, not in the database?
My data store has a primary key on every table.
so it should be good.
I have the same thing than you,
no PK on my RDBMS and PK define on datastore and it works well
but I am on Sunopsis V3
I set up a separate test with one very simple table on the source which is Oracle 9i and an identical table on the target. I tried both the "JKM Oracle 9i Consistent (LOGMINER)" and the "JKM Oracle Simple" and recieve the requires primary key error when I try to start journaling. I added a primary key to the source and it goes past that step with no error.