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:

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"