Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 kimball methodology

Author  Topic 

Robowski
Posting Yak Master

101 Posts

Posted - 2014-02-17 : 04:06:18
I'm just coming to the end of my SQL 2012 MSCA and before going onto the MCSE would like to get a solid understanding of Kimball and designing Fact and Dimension tables. Can anyone recommend a good book to start with please?

Cheers

robvolk
Most Valuable Yak

15732 Posts

Posted - 2014-02-17 : 07:10:10
Have you read this one?

http://www.amazon.com/Data-Warehouse-Toolkit-Definitive-Dimensional/dp/1118530802

There are a number of other books by the same authors but that is the starting point.
Go to Top of Page

Lamprey
Master Smack Fu Yak Hacker

4614 Posts

Posted - 2014-02-17 : 12:26:40
quote:
Originally posted by Robowski

I'm just coming to the end of my SQL 2012 MSCA and before going onto the MCSE would like to get a solid understanding of Kimball and designing Fact and Dimension tables. Can anyone recommend a good book to start with please?

Cheers

I think everyone would like that. :) If are just using them for cubes or something it should be pretty simple. If you are using them for something other than that, you shouldn't. Heck, even the Kimball group can't see to figure out what a Fact and Dimension are. What do they have now 30-40 different types of dimensions? Sad days indeed.
Go to Top of Page

Robowski
Posting Yak Master

101 Posts

Posted - 2014-02-18 : 06:59:59
quote:
Originally posted by robvolk

Have you read this one?

http://www.amazon.com/Data-Warehouse-Toolkit-Definitive-Dimensional/dp/1118530802

There are a number of other books by the same authors but that is the starting point.



No i haven' but it did come up in a few searches so I will look to get this one as a starting point then. thanks very much!
Go to Top of Page
   

- Advertisement -