Hi hoffy

Yes - one of the reasons you might want a data warehouse is to to keep historical records when your source transaction systems don't, i.e. after they have been "purged". To achieve this objective, purged records must remain in the warehouse, and they may look no different from "normal" records that still exist at source.

Conversely, records that are true deletions at source must be removed from the warehouse. They are qualitatively different from purged records in that they represent facts that are no longer true, rather than facts that are still true but no longer represented at source. 

?

To make this work you need to ensure that purged records don't appear to ETL processes as deletions. This requires source system extracts to indicate when a record has been deleted at source, and *not* to indicate a record deleted when it has merely been purged (or something similar).

Richard