Skip to main content

Posts Tagged ‘soft delete’

Oracle Data Integrator (ODI) – Logical or “soft” deletes

Logical deletes are a common practice when loading dimensions in a data warehouse. If a dimensional record is deleted in the source database, it may need to continue to exist in your data warehouse. In my recent project, this was one of the requirements set during the design phase. Since ODI was being used as […]