Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Herman van Midden

SQLServerCentral.com profile

   Items 1 to 1 of 1   
 

Implementing, loading and optimizing a Type 2 Slowly Changing Fact Table

This article shows how to implement a Slowly Changing Facts Table, how to overcome the problems encountered when using the MERGE statement to process the data and suggest a minimal set of indexes to aid data loading and quering.   Read more...
Rating: |  Discuss |   Briefcase | 5,356 reads
   Items 1 to 1 of 1