• kevin.obrien 66193 (11/9/2016)


    The problem I now have is that there are multiple FKs in the Fact table pointing to the one Dim table.

    Is this ok? Or is there a better, more efficient way of designing this?

    This is fine and absolutely normal, think of i.e. date dimensions for order date, delivery date, payment date and expiry date, you wouldn't want to have multiple physical instances of the date dimension, rather instantiate the same date dimension multiple times.

    😎

    Word of caution, a single instance of a dimension table used many times in a model will most likely result in an empty result set.