MSBI (SSIS/SSRS/SSAS) Online Training

Tuesday, July 20, 2010

SQL Server Data Warehouse basics

Hi Guys,
Before going to start any datawarehouse project, every developer should know the below basic concepts on datawarehouse with Sql Server.
It’s really nice article from Robert Scheldon.
Pls go thru this.the below topics are covered in the post.
· The Data Warehouse
· Data Warehouse vs. Data Mart
· Relational Database vs. Dimensional Database
· Dimensional Database vs. Multidimensional Database
· The Data Model
· The Star Schema.
· The Snowflake Schema
· The Star Schema vs. the Snowflake Schema.
· The Fact Table
· The Dimension
· The Surrogate Key
· The Date Dimension
· The Slowly Changing Dimension.
· The Data
~Ravindra
http://www.simple-talk.com/sql/learn-sql-server/sql-server-data-warehouse-cribsheet/

1 comment:

leamalaga03 said...
This comment has been removed by a blog administrator.