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 tables in to one table in the model?
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
4 Replies
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
the issue in this model is that i have orders with line level data, amount qty and so like in classic module,
but , this company have data of Authorization process with every order, and they analzye the time its take to apporove a order, and every order has max up to six signers, so i thoght to hold this infromation in another table in header level to not replicate the data
is that a good idea?
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!