This discussion is archived
1 Reply Latest reply: Mar 29, 2013 3:01 PM by Ayush Ganeriwal RSS

Consistent CDC implementaion if table has self join

948202 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points