Data Manager - Cleanse
Assets 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 - this step is to ensure that the table in the staging database is valid.
Table Preparation - the table is prepared for cleansing functions to be run.
Cleansing rules - for each rule you have defined in Cleanse and Import > Cleansing rules, a row will appear here showing the results of the cleansing rule and the runtime.
Post-Run - the table is prepared for finalisation.
Finalise - changes are saved to the underlying database.
Data must be mapped before it can be Cleansed or Imported.
Was this helpful?