Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Modeling - schema

HI ,  what is the more efficient way to work when you have an Order_header table and Order_item level table, should i work with both table and create relationship between ? or should i merge the t...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , You should merge. We prefer star schema, where we would like these two as single fact.

     

    If needed Order_header  can also be a dimension

Anonymous's avatar
Anonymous
Not applicable
4 years ago

amitchandak 

thanks!!

i was not sure which way is the best practise