1 Reply Latest reply on Mar 29, 2013 10:01 PM by Ayush Ganeriwal-Oracle

    Consistent CDC implementaion if table has self join


      My requirment is to implement Consistent CDC - Since Pk-Fk relationship is defined at Database level for tables.
      Couple of Q's i have and they are below:

      1.How can do if table has self-join?
      again Table1(Parent) will be Child for someother table. How to go ahead with this type of scenario.How to specify the Order for this table
      EX: Customer is parent ;Client is child to this. Again Customer is Child to Person table.
      3.hierarchy option in Datastore will be useful? if anyone use please share me the steps.
      4.Also i am doing this in my dev, can anyone tell me how to migrate the same to TEST environment.CDC migration.

      Let me know if need more details.