SQL Clone
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
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 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-Addicted
SSC-Addicted (406 reputation)SSC-Addicted (406 reputation)SSC-Addicted (406 reputation)SSC-Addicted (406 reputation)SSC-Addicted (406 reputation)SSC-Addicted (406 reputation)SSC-Addicted (406 reputation)SSC-Addicted (406 reputation)

Group: General Forum Members
Points: 406 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
Say Hey Kid
Say Hey Kid (681 reputation)Say Hey Kid (681 reputation)Say Hey Kid (681 reputation)Say Hey Kid (681 reputation)Say Hey Kid (681 reputation)Say Hey Kid (681 reputation)Say Hey Kid (681 reputation)Say Hey Kid (681 reputation)

Group: General Forum Members
Points: 681 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
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 Visits: 439
Thanks a lot for your help.
Ben Sullins-437405
Ben Sullins-437405
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1231 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
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

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

Thanks a lot again.
dtevlin
dtevlin
SSC Veteran
SSC Veteran (200 reputation)SSC Veteran (200 reputation)SSC Veteran (200 reputation)SSC Veteran (200 reputation)SSC Veteran (200 reputation)SSC Veteran (200 reputation)SSC Veteran (200 reputation)SSC Veteran (200 reputation)

Group: General Forum Members
Points: 200 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