Tuesday, 5 October 2010

[DW] Data Warehouse / Warehousing links

  • DW crib sheet

    http://www.simple-talk.com/sql/learn-sql-server/sql-server-data-warehouse-cribsheet/






  • SQL SERVER Merge information to handle SCD type 1, and 2.. (An SQL alternative to the SCD)

    http://www.bimonkey.com/2010/05/an-sql-alternative-to-the-scd/






  • Kimball group SCD pdf

    http://www.kimballgroup.com/html/08dt/KU107_UsingSQL_MERGESlowlyChangingDimension.pdf






  • Benny Austin - Alternatives to SSIS SCD Wizard Component

    http://bennyaustin.wordpress.com/2010/05/29/alternatives-to-ssis-scd-wizard-component/
  • No comments:

    Post a Comment