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.