Welcome to TechNet Blogs Sign in | Join | Help

Andrew Fryer's Blog

SQL Server Relational and Beyond

News

  • This posting is provided "AS IS" with no warranties, and confers no rights.
  • Technorati Profile

Browse by Tags

All Tags » Data Mart   (RSS)
Slowly Changing Dimensions and Surrogate Keys
You would expect there to be a record and hopefully only one record for each sales person in a typical sales system and another record in another table for each of the customers. But what happens when a one of these sales people gets assigned to a different Read More...
The Dimensional Model
What's different about a data warehouse is that all of the information from the line of business or source systems gets rearranged into two types of information: Dimensions contains a group of descriptive attributes. An example is a product where we have Read More...
Business Intelligence, Data Warehousing, and Data Marts
The terms Business Intelligence, Data Warehousing, and Data Marts are used interchangeably by many people so I thought it would be good to explain the differences. The data warehouse is the repository for all the data to be analysed and reported on without Read More...
Page view tracker