DTM Data Scrubber is a set of intelligent tools for data verification and scrubbing. Depending on user-defined rules and data properties, the program either creates a report about the actual state of affairs or performs database data correction. The program supports two sets of rules - for verification and for cleaning. The rules of the first type describe what the correct data should look like so each table field can have only one rule of this type. The rules of the second type describe the types of problems that can happen to data values. Together with this type you can specify the action the program should perform for problem correction. There can be several rules of this type for each field and the program will perform the action corresponding to the detected conditions.
What is new in this release:
Version 1.10.08 has fixed patter engine.
Requirements:
ODBC, IDAPI, OLE DB or Oracle Call Interface
Limitations:
5 rules per project, 20 changes per rule
Comments not found