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...