I have a fact table that has 'Order' information and in this table was a fact called 'SalesRep'. This is no longer a fact but should now be considered a slowly changing dimension because the sales rep will change historically. Therefore, for each of the 2 million orders in the fact table, I may have to update many records if the sales rep changes. I wanted to create a small dimension table to manage this information with just the ordernumber and salesrep field, but I'm finding issues. I'm at the point where I've included the OrderNumber in the dimension, but I'm over 64,000 members. I've tried hiding it in the dimension, but same issue. Also, since I really don't care to show the OrderNumber, I excluded it from the dimension, although required in join to fact table. But I don't believe I can do an incremental update to the dimension at the OrderNumber level and have this work the way I need it to. Stuck?