Handling logical deletes in the Data Warehouse

You may also like...

1 Response

  1. June 18, 2016

    […] Following the Staging Layer architecture patterns: when records are loaded into the Staging Area they will be timestamped with the Load Date/Time Stamp (LOAD_DTS). It is also the role of the Staging Area ETL to capture the Event Date/Time (explained in more detail in the post covering Data Vault ‘time’) as well as logical deletes. […]

     

Leave a Reply