title: Fact Table Construction on Multiple Dimensions on Membership
body: <p>We are building a data warehouse and having an issue with construction of a fact table. Our company enrolls members on various levels of membership, promotions, and rates. We would like to create a fact table that could display all current membership information with the ability to roll out old information or changes to the membership. The tables we are using are as follows… </p>
  
  <p>(Member Status | Start Date |End Date)</p>
  
  <p>(Member Privilege | Price | Cycle | Start Date | End Date)</p>
  
  <p>(Member Promotion | Associated Discount | Start Date | End Date)</p>
  
  <p>(Member Type | Start Date | End Date)</p>
  
  <p>(Personal Information | Address | Phone | Ect)</p>
  
  <p>We would like the fact table to display all this information based upon Personal Id. (Personal information needs to remain a dimensional table without many to many relationships due to this information is used in other fact tables.) The issue is that we could have multiple privileges or promotions attached to one member. Is it better to have these be independent fact tables or what is the best way to get this information into one table? </p>