Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have this table of products and their associated representative
I also have a fact table with the fields Order, Date, Product, and Sales.
I want to find a way to join the reps associated with each product in the fact table--however I do not know what the best practice is for this since there are multiple reps assigned to a single product.
Here's an example of what a row in the fact table looks like