title: Benefits of using Staging Database while designing Data Warehouse
body: <p>I am in process of designing a Data Warehouse Architecture.
  While exploring various options to Extract data from Production and putting into Data Warehouse, I came across many articles which mainly suggested following two approaches - </p>
  
  <blockquote>
    <ol>
    <li>Production DB ----> Data Warehouse (Star Schema) ----> OLAP Cube</li>
    <li>Production DB ----> <strong>Staging Database</strong> ----> Data Warehouse (Star Schema) ----> OLAP Cube</li>
    </ol>
  </blockquote>
  
  <p>I am still not sure which one is the better approach in terms of Performance and reducing processing load on Production database.</p>
  
  <p>Which approach you find better while designing Data Warehouse ?</p>