Further questions to the OP

😎

1) Do you really need the OrderID in the table? If the model has something like [Customer]---<[Order]>---[Produc] construct the OrderID is redundant as the Orders Fact should take the dimension keys of the model's dimensions ie. Customer, Product, Date, Demographics etc. and no table should hold a foreign key relation to the Orders table.

2) Is your transaction model a single product per order with the quantity and the price of the product?

3) How do you handle price variations, discounts etc.?