Product Home
DTM Data Scrubber Online Documentation
Product Profile
Data Verification
Connect
Data Scrubbing
Execution
Log page
Types of Data Checks
Regular Expressions
Actions
How to...
Settings
License
Support
Install
Uninstall
Upgrade
Database Tools
Glossary

Scrubber Rules

Data Scrubbing rules describe the types of problems that can happen to data values. You can specify the action the program should perform for problem correction.

The program will perform the action for all records where field values satisfy the specified criterion. If the rule is marked as terminate and its conditions are fulfilled, this field of the current record is not checked anymore.
For example, you want to replace all empty field values with the figure 10. In this case you should select "Is this value empty" for checking, and specify replace as an action, with 10 as a parameter. For most popular DBMS you can use built-in functions as parameters and in expressions.