Configuration Guide

10.4

Back Next

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

Rule SQL

section:

WHERE S.<Delete flag column name> LIKE '<Value of delete flag column for partial delete>'

You must not enable

Reserve Minimum Trust

for the column.

Consensus Delete

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Configuration Guide

Configuration Guide

Setting Up Hard Delete Detection for Consensus Delete with End Date

Setting Up Hard Delete Detection for Consensus Delete with End Date