0

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?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
zouhair zouita
  • 145
  • 2
  • 2
  • 7
  • What is the problem you are facing with creating the Order Dim? Where is this bridge table - in your transactional model or your warehouse model (as I can't see it in either) - and why is this affecting your ability to create a dimension table? – NickW Jun 17 '22 at 15:25
  • And why is DimDate a DirectQuery table from another databsae?!? Switch it to Import. – David Browne - Microsoft Jun 18 '22 at 20:57

0 Answers0