I have a situation where there can be multiple salespeople on an order. The fact table is a list of orders.
I'm not sure of the best way to handle this. I could create several columns but that design, I believe, is bad. The other option is to have a single salesperson column in the fact table. However, that means I'll have repeating data. But I don't see a better option.