title: One or multiple fact tables?
body: <p>I am trying to build a data mart.</p>
  
  <p>I have lot of dimensions, and couple of measures - facts. Every measure is connected to all dimensions in term of business. There is the standard approach that there will be one big fact table with all measures. </p>
  
  <p>But I have an idea: What If I have separate fact tables for each measure? What it will do with database performance, solution extensibility etc? </p>
  
  <p>EDIT:::
  there will be huge solution based on olap cubes in really complex corporate environment. So the needs are easy extensibility and maintenance at first, then performance</p>