title: Transforming OLTP Relational Database to Data Warehousing Model
body: <p>What are the common design approaches taken in loading data from a typical Entity-Relationship OLTP database model into a Kimball star schema Data Warehouse/Marts model?</p>
  
  <ul>
  <li>Do you use a staging area to perform the transformation and then load into the warehouse?</li>
  <li>How do you link data between the warehouse and the OLTP database?</li>
  <li>Where/How do you manage the transformation process - in the database as sprocs, dts/ssis packages, or SQL from application code?</li>
  </ul>