Product Home
DTM Data Scrabber Online Documentation Prev Page Prev Page
General Information
Product Profile
Data Verification
Data Scrubbing
Connect
Quick Start
Direct Connection
Connect to Desktop File
Data Sources
DSN File
OLE DB Connection
Connection Profile
Connection Information
Troubleshooting Guide
Types of Data Checks
Column to column
Expressions
Regular Expressions
Actions
Cleaning Script
Execution Console
Report Viewer
Project Properties
Project Report
Command Line
Console Mode
Log Viewer
How to...
Settings
Hot keys
SQL Console
Additional Information
License
Demo and Full versions
Support
Install
Uninstall
Upgrade
Trademark Information
Database Tools
Glossary

Verification Rules

Data verification rules describe what the correct data must look like. The program will add all field values of the selected table that don't match the criterion set in the rule, to the report.

DTM Data Scrubber: verification rule definition

"Not" modifier reverse the condition. For example "is null" with "not" option means "is not null".
"Ignore case sensitivity" options means the program should compare string values without case. "MAR" equals to "mar" and "Mar" as example.