title: Understanding slowly changing dimension (SCD) type 5 and 7 with examples
body: <p>I'm trying to understand how SCD Type 5,6 &amp; 7 work.</p>
  
  <p>I read this <a href="http://www.kimballgroup.com/2013/02/design-tip-152-slowly-changing-dimension-types-0-4-5-6-7/" rel="nofollow noreferrer">article</a> of Kimball Group and <a href="https://stackoverflow.com/questions/17351737/slowly-changing-dimension-what-is-pure-type-6-implementation">stack overflow</a> answer on Type 6.</p>
  
  <p>I could understand Type 6 concept, how it works and when to use it.</p>
  
  <p>However, I'm still unable to understand how type 5 &amp; 7 work and when to use them.
  Explanation of type 5 &amp; 7 with examples is highly appreciated. </p>
  
  <p>Thanks in Advance.</p>