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
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?