When is a change a ‘change’?

You may also like...

2 Responses

  1. June 5, 2017

    […] When is a change a change? This post outlines the concepts behind effects of row condensing and why additional checks are needed to avoid record sets with (potentially) many redundant rows. […]

     
  2. December 5, 2017

    […] If you imagine you start capturing transactions early and complete your Data Warehouse design / model some time later, you can imagine you need to find a way to ‘replay’ these transactions to load into the Data Warehouse. This requires the DWH patterns such as Hubs, Links and Satellites need to be able to do this, which is a complication of the pattern (but very worth it). Hubs and Links natively support this due to their definition, but time-variant tables such as Satellites require special attention. For an idea please read this post. […]

     

Leave a Reply