Data Marts Slowly Changing Dimensions

In my last post, I put in the diagram a Type 1 and a Type 2 insert.  I think I need to elaborate on that just a bit.  Type 1 updates don't have any concept of history.  Type 2 updates are what I use to encapsulate all history types (Type 2, Type 3, Type 4, and Type 6). 

These dimensions are where Ralph Kimball's dimensional modeling come in. 

So before anyone points out that I didn't talk about the other types in my diagram, Type 2 updates for me is synonymous with all history in a data mart.

Print | posted @ Friday, February 08, 2008 12:51 AM

Comments have been closed on this topic.
Twitter