title: Database - Fact Table and Dimension tables
body: <p>I have database with 10 tables. Each table has 70 monthly databases data since 2011 to current and which will increase every month going forward. Each table has Identity ROW_ID with primary key Clustered index. Also there are Non Unique Non Clustered indexes on ID and Date in each table. There are more than 90 million rows in tables. </p>
  
  <p>All I need to create Fact table and then Dimension tables from those 10 tables to create data warehouse cube. I did search so many blogs in Google and could not able to figure out the solution. Can anyone suggest what is the best approach to create Fact and Dimension tables. </p>
  
  <p>Final solution is if once cube build with 70 monthly dtabases data cube needs to refresh every month only to load monthly data. I do not want to make cube reload everything from 2011.</p>
  
  <p>Any suggestions will be helpful.</p>
  
  <p>Thanks.</p>