Skip navigation links

Browse

Ask the Librarian

Note the above only searches this section, for site searches use the overall search function. Help: Searching, Tag Searching

The MySQL Librarian collects the best of the web when it comes to MySQL! If you have something to add to the Librarian, please do so. Help us keep it current and relevant to the MySQL Community!

Browser Tools

  • Bookmarklet: Add to Librarian
    Drag link above to your browser (Firefox/Safari) toolbar to add URLs to the MySQL Librarian from anywhere.

Profile

Top Voted (Last Month)

  1. Does MySQL support Julian Dates? Vote!
Articles
Loading a dimension table with SCD1 and SCD2 attributes
Add to My Link Library +0 Vote Up -0Vote Down
posted by Roland Bouman on Fri 10 Jul 2009 20:25 UTC
Tags:
(edit) date warehouse, slowly changing dimension, type 1 scd, type 2 scd, type 1/type2 hybrid scd
Learn how to load a dimension table that contains some attributes that need to be updated (type 1 slowly changing dimension) and some attributes that need to be versioned (type 2 slowly changing dimension) using pure SQL
Tags:
(edit) date warehouse, slowly changing dimension, type 1 scd, type 2 scd, type 1/type2 hybrid scd



Report this link: