Business Intelligence #04b: Implementing Slowly Changing Dimensions in the Data Flow

Play Business Intelligence #04b: Implementing Slowly Changing Dimensions in the Data Flow
Sign in to queue

Description

This screencast covers one of the most common scenarios when building a data warehouse.  It introduces the concept of Slowly Changing Dimensions (SCD) and how to solve that challenge with SQL Server Integration Services (SSIS).

This screencast is the first in a series BI Developer screencasts recorded as part of a workshop built on SQL Server 2005 that have been delivered around the globe by Microsoft and Microsoft Partners.  This training event takes the student through the Microsoft BI Platform giving a BI Developer the introduction and basic comfort needed to tackle a BI project using Microsoft technology.

If you missed the first screencast in this series I highly recommend that you watch it first as it provides a great overview of Microsoft BI technology.  Additional screencasts will be published under the "SQL+Server" so subscribe to it now!

Embed

Download

Download this episode

The Discussion

  • User profile image
    ZachSkyles​Owens

    We are really interested in your feedback on Implementing Slowly Changing Dimensions in the Data Flow.

    What would you like to see done differently?

    What do you think worked well?

    Feel free to leave a comment here or reply privately.

  • User profile image
    ZachSkyles​Owens

    There is apparently an issue with the way these videos are encoded and Silverlight player...  You can watch these videos by clicking on the "Downloads" link then selecting "WMV".  I'll see what I can do to get this fixed.  Sorry for the inconvenience.    

  • User profile image
    sadlock

    According to a study, those living PDF to GIF Converter in well-lit towns or cities are more likely to become obese than country dwellers – even if they eat the same amount.Scientists believe that the glow of PDF to BMP Converterstreet lights encourages late-night snacking, and because food eaten close to bedtime is less likely to be burned off, it is often stored as fat.But beore you swap calorie counting for a blackout blind, it seems that all unnatural light could have the same effect – includingPDF to JPG Converter that from computer screens and TVs. American researchers found that mice that were exposed to a dim light at night put on 50 per cent more weight than those whose cages were left dark.

Add Your 2 Cents