Data Manager - Cleansing rules

Cleansing Rules are automations that can be added to the Cleanse operation to eliminate missing, erroneous, or duplicate information from your data. Cleansing Rules are linked to object classes.

There are three groups of Cleansing Rules, which differ in how they remove data:

• Exclude Cleansing Rules rules that exclude data from the Golden Record.

• Filter Cleansing Rules denote rules that filter data from the Golden Record. Filtered records are denoted with a ? in the Cleansing Statistics screen.

• Remove Cleansing Rules denotes rules that removed data from the Golden Record.

Two Cleansing Rules are included with all object classes:

1. Exclude null or empty primary keys - This rule excludes objects with primary keys that either have no value (NULL). This rule is linked to the reason Null or Empty Primary Key. This rule is typically the first rule in the list of rules.

2. Remove primary key duplicates - This rule removes primary keys that are found to have duplicates. This rule is linked to the reason Force Cleaned. This rule is typically the last rule in the list of rules.

In total, there are six default Cleansing Rules. To see the default cleansing rules based on the object class and data source, go to Data Manager > Settings > Default Cleansing Rules.