Skip to content Skip to sidebar Skip to footer

Slowly Changing Dimension - What Is Pure Type 6 Implementation

I am trying to understand pure type 6 SCD implementation from WIKI which says mainly three points Having a Type 2 surrogate key for each time slice can cause problems if the dimen

Solution 1:

The point of "type 6" or "hybrid" processing is that you track changes by adding a new row for each new version but then you update some of the attributes on previous versions to reflect the current state of data. That way the data can be filtered and rolled-up across all versions for reporting purposes.

There's another explanation here: http://www.kimballgroup.com/wp-content/uploads/2012/05/DT15CombiningSCD.pdf

Example:

Type 6 Example

http://www.kimballgroup.com/2013/02/05/design-tip-152-slowly-changing-dimension-types-0-4-5-6-7/

Post a Comment for "Slowly Changing Dimension - What Is Pure Type 6 Implementation"