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

    Consistent CDC implementaion if table has self join

    948202
      Gurus,

      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?
      2.Table1(Parent)->Child1(child)
      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.

      Thanks