I have a FactSales table that is down to the line item.
I also have a sales order detail dimension that contains attributes that don't belong in the fact table.
Now, I'm in need of incorporating sales header information into the data mart.
Create a sales header dimension and place the key in the fact table.
Create a sales header dimension and place the key in the sales order detail dimension.
Incorporate the header info that I need (not a lot) into the sales order detail dimension. (This seems unscalable and a bad design but it's an option so I'm mentioning it)
It seems like option 1 is the best but I would appreciate if someone could shed some light on the pros and cons.