Slowly Changing Dimensions

  • agrawal.prakriti

    Mr or Mrs. 500

    Points: 572

    Comments posted to this topic are about the item Slowly Changing Dimensions

  • This was removed by the editor as SPAM

  • Arjun SreeVastsva

    SSCertifiable

    Points: 7135

    Type 1 Slowly Changing Dimension data warehouse architecture applies when no history is kept in the database. The new, changed data simply overwrites old entries. This approach is used quite often with data which change over the time and it is caused by correcting data quality errors (misspells, data consolidations, trimming spaces, language specific characters).

    Type 1 SCD is easy to maintain and used mainly when losing the ability to track the old history is not an issue.

  • Arjun SreeVastsva

    SSCertifiable

    Points: 7135

    Slowly changing dimension Type 2 is a model where the whole history is stored in the database. An additional dimension record is created and the segmenting between the old record values and the new (current) value is easy to extract and the history is clear.

    The fields 'effective date' and 'current indicator' are very often used in that dimension and the fact table usually stores dimension key and version number.

  • SQLRNNR

    SSC Guru

    Points: 281252

    Nice question. Thanks

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Paul White

    SSC Guru

    Points: 150442

    I look forward to Raju The Leader (???) enlightening us all about Type 3 SCDs :laugh:

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply