Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Want to learn DW concepts : FACT tabels, Dim tables, CUbes


Want to learn DW concepts : FACT tabels, Dim tables, CUbes

Author
Message
tejinder pal singh
tejinder pal singh
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 439
Hi,

Can any one help in learning datawarehouse concepts . I work with SQL Serever DBA/Development stuff.
I want to learn DW concepts and Basics
ANy help will be highly appreciated.

Thanks
TJ
Stefan K
Stefan K
SSC Journeyman
SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)

Group: General Forum Members
Points: 94 Visits: 44
Hi,
there are a lot of books on the market. For a general overview about the concepts I would suggest to read the books from Kimball. There is also a special book for SQL Server 2005 on the market.

http://www.amazon.de/Microsoft-Data-Warehouse-Toolkit-Intelligence/dp/0471267155

There are a lots of Webcasts available from Microsoft about their data warehouse technologies. You could check msdn or search by google.


Kindest Regards,

SK
Dan Colbert-387424
Dan Colbert-387424
SSC Veteran
SSC Veteran (291 reputation)SSC Veteran (291 reputation)SSC Veteran (291 reputation)SSC Veteran (291 reputation)SSC Veteran (291 reputation)SSC Veteran (291 reputation)SSC Veteran (291 reputation)SSC Veteran (291 reputation)

Group: General Forum Members
Points: 291 Visits: 338
The Kimball Group website (http://www.kimballgroup.com) is also a great source for some fundamental articles.

Dan
tejinder pal singh
tejinder pal singh
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 439
Thanks a lot for your help.
Ben Sullins-437405
Ben Sullins-437405
Old Hand
Old Hand (337 reputation)Old Hand (337 reputation)Old Hand (337 reputation)Old Hand (337 reputation)Old Hand (337 reputation)Old Hand (337 reputation)Old Hand (337 reputation)Old Hand (337 reputation)

Group: General Forum Members
Points: 337 Visits: 267
The Channel9 Wiki has some great screen casts demonstrating how to accomplish a lot of the tasks with the SQL 2005 BI tools. It doesn't however explain conceptually to well what a DW is and why it makes sense. For that I would recommend turning to the Kimball group.

http://channel9.msdn.com/wiki/default.aspx/Channel9.SQLServer

Hope this helps!

Cheers,
Ben


Cheers,

Ben Sullins
bensullins.com
Beer is my primary key...
tejinder pal singh
tejinder pal singh
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 439
Thanks a lot. It has great stuff for watching.

Thanks a lot again.
dtevlin
dtevlin
Valued Member
Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)Valued Member (66 reputation)

Group: General Forum Members
Points: 66 Visits: 77
There are two compeating methodologies in the DW area and have been for a while. Kimbell with the Data Warehouse Lifecycle Toolkit and Inmon with the Corporate Information factory.

We covered both books in grad school and I use a hybrid method most of the time, but it is very useful to know both.

--Dave



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search