DTM Data Scrubber

Data cleansing process is a resource consuming task that the companies using large databases have to take up on a regular basis. For collecting the data, companies consult a multitude of sources and more often than not, the format of the data may vary from one source to another. Many a times, problems may also arise while importing the data for which timely cleansing of data is extremely essential. So data scrubbing is a process of editing and removing data items from database that is incomplete, duplicate, and incorrect or improperly formatted, which can be easily achieved with the help of DTM Data Scrubber v.1.06.01.

DTM Data Scrubber is an application by DTM soft for undertaking automated data verification and scrubbing. The program either automatically makes the necessary changes to the actual database or creates documented reports of all the changes to be made, according to the pre-specified set of rules defined by the user and administrative policies. There are two types of rules that the user can set and are implemented at two levels - verification and cleaning. The first type rules define the format of data which is a standalone rule for each field of data table. The second type of rules specifies the types of glitches possible in the values of data in the database. The user can also specify the potential correction needed to be executed to the incorrect or mis-formatted data values. For each field in the table, there can be number of rules and the program will perform actions according to the pre-specified policy rules.

To conclude with, DTM Data Scrubber v.1.06.01 is a nice program for editing the values in the database and thoroughly spotting out any potential corrections, thereby saving on time, leading it gain a decent score of four and a half rating points.

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.