Home Forums Data Warehousing Strategies and Ideas Is this part of product dimension RE: Is this part of product dimension

  • May 29, 2014 at 4:40 am

    #1717279

    ps_vbdev (5/29/2014)

    Thanks Koen

    How do you know what and when something should be in the dim tables or fact, this is what im find hard as just starting in DW, just experience i guss? Was reading your blog post on less than dot some nice articles :0

    Thanks.

    If it is something you measure (and typically changes over time), it is a fact.

    If it is purely informational (a descriptive attribute), it goes into the dimension.

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