Forum Discussion
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...
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
HI amitchandak
thank you for your advice.
i have a case which we have a authorization process for purchase orders :
the data is stored on header level:
| Order Key | sign date1 | sign date 2 | sign date 3 |
| A1231323 | 18/02/2022 | 19/02/2022 | 21/02/2022 |
thats is why i though to have it on another table in the model , what is your opininon?
thanks!