Setting Up Hard Delete Detection for Consensus Delete with End Date
Setting Up Hard Delete Detection for Consensus Delete with End Date
After you complete the general configuration to detect hard deletes, set up the procedure for consensus delete with an end date for a staging table.
Configure the
MDM Hub
to detect hard deletes.
Identify the stage jobs in which the
MDM Hub
must detect hard deletes.
Insert the staging table details and other required metadata into the hard delete detection table.
In the
Schema
tool, enable the
Trust
and
Validate
checkboxes for the column name that contains the value of the delete flag for any hard deleted records.
If you use an end date, enable the
Trust
and
Validate
check boxes for the end date column name.
In the
Systems and Trust
tool, specify trust settings for the delete flag column name, and the end date column name for each source system.
The value for
Decay
must be the same for all source systems of the base object.
In the
Schema
tool, set up validation rule for the delete flag column name for each base object that you configured for Hard Delete Detection. You must set the partial delete flag to a lower trust value than the active, or fully deleted flag.
Select
Validation Rules Setup
for the base object.
The
Validation Rules
page appears.
Click the
Add validation rule
button.
The
Add Validation Rule
dialog box appears.
Enter a rule name and select the
Custom
rule type from the list.
Note: Do not insert a comma into the rule name. This can disrupt the order of the validation rules.
Select a downgrade percentage and specify a rule in the following format in the