Delete (_DEL) Tables

The ETL process compares the primary keys stored in the data warehouse with the keys in the corresponding Primary Extract (_PE) table.

Any record that exists in the warehouse but is no longer present in the _PE table is identified as a record that has been physically deleted from the source system.

The primary keys of these deleted records are loaded into the corresponding Delete (_DEL) table. Each _DEL table contains the list of records that require soft delete processing.