When building dimensional models it is crucial to decide on how changes in source data will be represented in dimension tables. This phenomena is called slowly changing dimensions. When it is not necessary to preserve the history, a Type 1 Slowly...
Archive for September, 2014
Merge statements provide a flexible approach to manipulate data in a "target" table based on a join to a "source" table. This enables users to perform a large number of updates and/or inserts in a target table using a single...