Cleanse
Data Manager is included in all Service Collection Premium and Enterprise plans.
The cleanse operation filters duplicate, erroneous, or unneeded information from your staged data. Cleansing is done by running a number of cleansing rules against the staged data.
Cleansing performs the following operations on your data source, in sequence:
Validation – ensures that the table in the staging database is valid.
Table preparation – prepares the table for cleansing rules to be run.
cleansing rules – for each rule you have defined in Data sources > Configuration > cleansing rules, a row will appear here showing the results of the cleansing rule and the runtime.
Post-run – prepares the table for finalization.
Finalise – saves changes to the underlying database.
Data must be mapped before it can be cleansed or merged.
Was this helpful?