The

MDM Hub

has default delete flag values. You can configure the

MDM Hub

to provide an end date value along with a delete flag for base object records.

Base objects have the following default delete flag values:

Active

Indicates that the record is active in all source systems. To change the value, set the value in the DELETE_FLAG_VAL_ACTIVE column to some other value. Default is A.

Inactive or fully deleted

Indicates that the record is hard-deleted in all source systems. To change the value, set the value in the DELETE_FLAG_VAL_INACTIVE column to some other value. Default is I.

Partially deleted

Indicates that the record is deleted in some source systems. To change the value, set the value in the DELETE_FLAG_VAL_PARTIAL column to some other value. Default is P.

Determine the base objects that need delete flags and possibly end dates. Ensure that you include the appropriate columns in the landing tables and staging tables associated with the base objects. Also, verify that you configured the hard delete detection table in the repository to detect hard deletes from the staging table.