I have FactOrders with date,saleid,productid,salesorderno,purchaseorderno,qty,price
There are date and product dimension that link to FactOrders on date and productid respectively.
Should sales order number and purchase order number be placed in FactOrder table or should I place them into a new dimension?