Many-to-many from relational design to dimensional design

81 Views Asked by At

This is my database design:

relational design

I make a data warehouse a with 2 fact table design as you show :

dimensional design

I want to add Order dimension but the problem is that there is bridge table between product table and order table by the way order table contain 830 rows and Order details table contain 2155 rows.

How can I create order dimension?

0

There are 0 best solutions below