Post reply

Updating your fact table when a scd changes

  • June 4, 2014 at 11:11 am

    #292024

    so you have a slowly changing dimension that has changed somehow say product color code has changed. youretl pics this up and inserts a new product record in the dimension.

    1) all the original fact that were ties to the old product code must stay in the fact table (so you cant be droping the database everytime the way i have seen some etls do)

    2) how do you now tie new sales to the new product when populating your fact table?

    any thanks

  • June 4, 2014 at 2:38 pm

    #1719012

    Every time you load facts into the fact table, you do a lookup to the product dimension using the product business key.

    You simply retrieve all the current records (meaning the record you last inserted with the new product color code), so you retrieve the surrogate key of the new product.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

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

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