Data Warehousing Design

Data Warehousing Design

• • Email
  
  how to do impact analysis in ssis packages to find database tables and stored procedures
  In this article you will learn how to perform impact analysis for sql server, ssis and other BI Objects.
  tags : ssis sql server impact analysis lineage analysis
  NayanPatel   -  6/8/2011   -  Comments: 1  -  Views: 2422
• • Email
  
  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
  indupriya   -  7/20/2010   -  Comments: 0  -  Views: 1720
• • Email
  
  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
  PatrickLeBlanc   -  6/4/2010   -  Comments: 0  -  Views: 1613
• • Email
  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
  PatrickLeBlanc   -  3/19/2010   -  Comments: 2  -  Views: 1612
• • Email
  Normalization vs. Dimensional Modeling
  This article is a basic overview and comparison between normalization and dimensional modeling.
  tags : normalization, dimensional, fact, star, snowflake
  ShawnHarrison   -  1/11/2010   -  Comments: 3  -  Views: 2465
• • Email
  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.
  PatrickLeBlanc   -  12/31/2009   -  Comments: 2  -  Views: 2040
• • Email
  
  Using Indexed views in SQL Server 2008
  An overview of Indexed Views
  kylewalker   -  11/29/2009   -  Comments: 2  -  Views: 916
• • Email
  Agile Development with Scrum
  In this article, you'll learn about the Scrum development methodology.
  tags : scrum, deveopment methodology
  BrianKnight   -  11/24/2009   -  Comments: 3  -  Views: 914