Sales and cost granular récords in a single fact table
Hi,
Thanks in a advance for your help. I am not sure if I should merge a sales tables that have Customers and Products as Dim with Cost records, that have Plant and Products as Dim. Both have the same level of granularity but there are many fields in sales that do not apply to Costs (such as Distict, routes) and viceversa (such as shifts and lines)
