Unless you are stuck doing a star schema might I suggest you look at Data Vault as a better design for a data warehouse? http://www.amazon.com/Modeling-Agile-Warehouse-Vault-Volume/dp/061572308X