Fervent Coder

Coding Towards Utopia...by Rob Reynolds
posts - 278 , comments - 431 , trackbacks - 0

My Links


Rob Reynolds

Subscribe to Fervent Coder RSS
Subscribe to Fervent Coder by Email

About Me

I manage several open source projects. Need...
   ...package management for Windows?
   ...automated builds?
   ...database change management (migrations)?
   ...your application to check email?
   ...a monitoring utility?

I also write for

Like what you are reading? Want to buy me a cup of coffee?
PayPal - The safer, easier way to pay online!


Post Categories


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 on Friday, February 8, 2008 12:51 AM | Filed Under [ DataWarehousing ]


Comments are closed.
Comments have been closed on this topic.

Powered by: