title: Data Warehouse Testing Approach
body: <p>I am working on testing space on Data Warehousing. In the scope I got newly created and dimensions and facts which should be validated. As per my knowledge and information got via browsing I would decide to cover for following </p>
  
  <ul>
  <li>Schema validation of Facts and Dimension tables as per spec</li>
  <li>Data duplicate check for Facts and Dimension table</li>
  <li>Look-up validation for dimension table </li>
  </ul>
  
  <p>Is there anything else that I can verify here?</p>
  
  <p>In addition just curious how can I check whether data correctly populated to Fact table and row count, correct surrogate keys etc. In developers point of view are they using DML scripts to load the data? </p>