CDC with parent-child tables

See more:

SQL

server

SSIS

Hi All,

I am using SQL Server Change Data Capture to track my changes in my Web Application. But the problem I am having is, if I have one page which is updating multiple Tables, parent and child tables in one transaction, how can I track all those tables transactions at one time, because sometimes page can update some tables and may not update other tables. As CDC is working on individual tables it is very difficult for me whether the transaction has updated particular tables. Can anybody please help me how to track the changes on the tables in that approach.

What I have tried:

I'm new to CDC and I'm not sure how to implement for parent-child tables