locked
create dimensions of data I will have in the future? RRS feed

  • Question

  • Hi experts,

     

    I am trying to build this datamart with clickstreams from a site… I checked the bibliography and most authors agree in all these dimensions:

     

    Date

    Time of day

    Part

    Vendor

    Status

    Carrier

    Facilities location

    Product

    Customer

    Media

    Promotion

    Internal organization

    Employee

    Page

    Event

    Session

    Referral

     

    To be honest, from my source I can only get less than half of them… But I could potentially get more of them in the future…

     

    My question is, should I create the dimensions (and the key in the fact table) for data I don’t have now and may get in the near future?

    My other option is create dimensions for data I do have, build the fact table, and then IF i get more data, to add the columns in the fact table + create the dimensions

     

     

    Thursday, February 15, 2018 1:14 PM

Answers

All replies