Forum Discussion
Efficiency - advice on structuring data
I am looking for some general advice. I have a moderate sized model (about 20 tables). Most tables link into the order table in a normal star schema but the order table then links down furth into...
Anonymous , Ideally in star schema both order header and lines should independent tables. You can merge columns in power query(what ever you need from another table), but on the model view, they do connect with each other.
As for the date table, you can not have two paths with order lines. one direct and one via order header. So one of the joins will become inactive or not work