4 Replies Latest reply on Jul 13, 2007 12:29 PM by 483490

    CDC without source primary key

      One of the sources on which I need to use ODI to keep data updated to my data repository has tables in Oracle 9i which have no primary key. I have no control over the source application and database, so can anyone tell me how I can set up change data capture without a primary key on the source?

      I prefer to use journalization which uses log mining, but want to know whether any of the journalizing options can work without a pk. When I try to start journalization, I get a "primary key required" message.