Using a view to implement SCD2 processing (preventing deadlocks)

SQLServerCentral » Latest topics

Using a view to implement SCD2 processing (preventing deadlocks)

Hi,

Question #1:

Scenario:
* I have a series of SCD2 source tables which are updated twice a week.
* I'm creating a downstream series of SCD2 target tables which are updated monthly.
* I am using a delta feed for the staging

more info...