New answers tagged

2

The more common and accepted way is that once a job lands on a server in an AG you start editing it: Add a first job step that checks whether this is the primary. Exit on success if it isn't. Otherwise continue onto the normal job step. This has been explored in a few other SE questions (they don't specifically relate to CDC which is why you didn't find ...


1

I highly recommend the 1st option of a bridge table. If you make sure the you capture the historical change on all three tables that would work fine, though I'd agree with you that the JOIN'ing is an issue. Just make sure that (in the JOIN clause) that the DateInserted and ValidTill match the ones that are in the fact table. More about bridge tables in here ...



Top 50 recent answers are included