Data Warehousing Design

• 
  Dimensional Data Model -- General Concepts
  This article covers the general concepts of data modelling in simple terms. A very brief overview of dimensions and measures is provided.
  tags:  Dimensional data, concepts, BI basics
  7/20/2010 6:13:15 AM    indupriya  -  Comments: 0  -  Views: [143]
• 
  Incremental Loads with Change Data Capture - Part 3: Creating the SSIS Package
  In the final article of this series, I will outline the steps required to build a SQL Server Integration Package that uses the change data to build a Slowly Changing Dimension (SCD).
  tags:  SQL Server, CDC, SSIS, SCD
  6/4/2010 9:32:21 PM    PatrickLeBlanc  -  Comments: 0  -  Views: [175]
• Incremental Loads with Change Data Capture – Part 2: Detecting Changes
  In this article I will provide you with a detailed explanation of how to identify changed data using the CDC tables and functions.
  tags:  Warehousing, CDC, SSIS
  3/19/2010 4:53:51 PM    PatrickLeBlanc  -  Comments: 2  -  Views: [442]
• Normalization vs. Dimensional Modeling
  This article is a basic overview and comparison between normalization and dimensional modeling.
  tags:  normalization, dimensional, fact, star, snowflake
  1/11/2010 12:00:00 AM    ShawnHarrison  -  Comments: 3  -  Views: [790]
• Incremental Loads with Change Data Capture – Part 1: Enabling Change Data Capture
  In this series I will explain how to enable Change Data Capture to do Incremental Data loads.
  12/31/2009 9:25:59 AM    PatrickLeBlanc  -  Comments: 2  -  Views: [561]
• 
  Using Indexed views in SQL Server 2008
  An overview of Indexed Views
  11/29/2009 8:53:40 PM    kylewalker  -  Comments: 2  -  Views: [210]
• Agile Development with Scrum
  In this article, you'll learn about the Scrum development methodology.
  tags:  scrum, deveopment methodology
  11/24/2009 9:25:59 AM    BrianKnight  -  Comments: 3  -  Views: [282]