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...
Site visitors since October 2015
Search this site
Upcoming Training and Speaking Events
Please check out the global Data Modelling Zone (DMZ) website at http://dm.zone/.
I look forward to seeing you at the upcoming one in DMZ Australia 2018 (March 5-6 in Canberra).
If you register, please use the discount code VosDMZAU.
Upcoming Data Vault Implementation and Automation training:
- - 2-day course in Amsterdam (TBD)
- - 2-day course in the UK (TBD)
- - 3-day course in Amberg, Germany - 9-11 April. Register here