Sample Header Ad - 728x90

CDC Capture Instance or State to ensure referential integrity

1 vote
1 answer
757 views
I'm implementing an SSIS/CDC based data warehouse solution and have a question relating to referential integrity on the destination database. As an example, I have INVENTORY_TRANSACTION in one table and PART in another table each with their own SSIS package for incremental loads. I don't want to have a situation where I have INVENTORY_TRANSACTIONS in the data warehouse that don't have an associated parent PART record. I've read quite a bit on the subject but I'm still unclear. Should I be using the same capture_instance on the tables that have related data so they all target the same LSN chain? Should I be using the same State name? Or, am I missing something entirely?
Asked by Shooter McGavin (908 rep)
Jan 17, 2018, 12:20 AM
Last activity: Jun 5, 2025, 04:22 PM