While working on a recent project I had a brief discussion on the implementation of logical deletes. This prompted me to define for once and for all how ETL should handle these occurences. This is, of course, assuming that some CDC mechanism provides the required details or you have the capacity to compare full sets of data to derive the logical deletes yourself. For this purpose I drafted a Design Pattern which should explain this...
Search this site
Upcoming Training and Speaking Events
3-day Virtual Data Warehouse / Data Vault Implementation Training - Utrecht, The Netherlands - June 19-21 2019. Register here!
3-day Virtual Data Warehouse / Data Vault Implementation Training - Utrecht, The Netherlands - June 24-26 2019. Register here!
DDVUG Round Table - Munich, Germany - July 2nd 2019. Additional information here.
Metafinanz Data Warehouse Automation Day - Munich, Germany - July 3rd 2019.