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
Last activity: Jun 5, 2025, 04:22 PM