Hello,
Question on data model design.
I have three tables. Fact table being production events. Two dimension tables - Job_Master that has one record per Job and fields such as Plant, Ordered Qty, Due Date etc. Job_Customer is a list of customers that have used product from that Job. There can be multiple customers per Job. The three tables all link with a key field %Job.
I choose to have both dimension tables connect using %Job field to Fact rather than using a snowflake schema of linking the Fact to Job Master and then Job Master to Job_Customer. I can't combine them to one dimension table as that would replicate the Job_Master details for each customer.
This works, but am curious if there are any known downsides, particularly in performance for front-end calculation. Should I be avoiding this design and instead using snowflake, or possible two separate key fields to join the tables.
Thanks in advance.
Michael
.png "Former Employee"){kind=icon}
