Home Forums Data Warehousing Strategies and Ideas Type II changes in Dimension tables and the associated surrogate key in Fact table RE: Type II changes in Dimension tables and the associated surrogate key in Fact table

  • April 24, 2014 at 2:18 pm

    #1708599

    Very important thing to know: the RentalFeeAmount, how is this calculated? How is this used?

    If it is a normal measure - additive and all that - option 1 is flat out wrong as you would double count amounts.

    But I guess more is going on here.

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