How do we use CDC for related tables such as a master and detail where master having the PK and some basic details such as created by created on etc and the details having the entity specific attributes?
How do I retrieve the CDC data for a single record modification by joining the master and details CDC tables?
Please suggest.