Data Quality Control System

New dfPower Studio 3.4 is a data matching, data standardization, and data analysis application designed to allow users to quickly and easily identify duplicate records, normalize inconsistent data, improve the merging capability of data from dissimilar data sources, and identify data intelligence issues.

As with previous versions, this release offers universal connectivity to more than 60 databases, including Oracle, SQL Server, DB2, Sybase, and Informix. In addition, it works with data directly within a database, eliminating the need to unload, manipulate, and reload data.

New features include:

• SQL generation: users can generate pure SQL based on automatically generated or manually developed standardization logic for use as part of a standardization process outside of the software, typically in a data load or transformation scenario.
• On-screen editing of generated standardization logic / schemes: users can extend and customize the results of the automatically generated standardization process directly on the scheme grid. Changes can be applied in a single instance or universally.
• Capitalization functionality: the software can be used to change the case as desired for any data within a database. Users can change data to proper, lower, and upper case with a few clicks, according to the manufacturer.

Additional software features include improved matching algorithms, improved clustering logic, GUI enhancements, and improved batch functionality.

DataFlux, 3801 Lake Boone Trail, Suite 150, Raleigh, NC 27607. Tel: 877-846-FLUX or 919-846-9000. Fax: 888-769-FLUX.