About 2 results
Open links in new tab
How to perform SCD2 using MERGE Upsert - social.msdn.microsoft.com
Aug 24, 2011 · This is what I am currently doing - but i think it is inefficient because after doing the EXPIRED_SCD2 checks using merge upsert I have to do a separate insert - by joining the source …
When to use a 'Fact dimensions' v a seperate Fact and Dimension table ...
Aug 2, 2011 · This highlights a problem with 'Fact Dimensions' in that they can't implement SCD2 since they are directly bound to fact in which case you are better of treating them as 'Regular Dimension' …