4 Replies Latest reply: Jul 13, 2007 7:29 AM by 483490 RSS

    CDC without source primary key

    483490
      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.