Designing A Data Warehouse: Part 1 Dimension Types

In this first part of a multiple part series, Brian Knight shows the different types of slowly changing dimensions you'll use and the business reason for using each type.

Owner of Pragmatic Works :: Brian Knight, SQL Server MVP, MCSE, MCDBA, is the co-founder of Jumpstart TV and SQLServerCentral.com. Brian has written and co-written 9 technical books. Brian has spoken at conferences like PASS, TechEd and Connections. Brian develops solutions with Pragmatic Works to migrate DTS packages to SSIS.

Shawn on 10/21/2008

Very informative and well explained.

Kenneth Wymore on 10/22/2008

Very good presentation. Look forward to more on the topic of loading a data warehouse

Leonel on 10/30/2008

Very interesting

dfwdba on 12/31/2008

When will we see part 2?

Tariq on 1/6/2009

video is nice, specific and very useful. I'm waiting for the 2nd one to come out. Thanks alot Brian

Dick Rosenberg on 1/7/2009

Whaere are the parts after Part 1?

TechyGirl on 2/7/2009

This was great! I can't wait to see part 2.

John on 2/12/2009

Good presentation, at a high level, over the design of a data warehouse. Now I’m even more intrigued on how to produce one.

Krishna on 2/17/2009

Very Informative.

xuhui duan on 2/25/2009

very good.

coorgun on 4/28/2009

a very good presentation, thank you! might be a little bit too fast for us, the not-native-speakers ;-) hoping&waiting for part 2,3,4, ... ;-)

Charles Carr on 7/23/2009

More in-depth examples would be good

delovan on 8/18/2009

The host should have prepared prior to recording the webcast.

Dean Gross on 9/15/2009

it would have been nice to see the examples of the type 3 and 4 dim tables

Deepthi on 3/9/2010

There were little static sounds during the first few minutes of this video. Please try to correct it.

Victor on 3/24/2010

Excellent presentation.. I suppose the other types are described in Part 2, 3..

David Branscome on 7/21/2010

Good overview. Now on to the details.