PowerCenter Data Cleanse and Match Option

Standardizing, Validating, and Correcting Enterprise Name and Address Data

The Data Cleanse and Match Option offers an ideal starting point for organizations that need to deal with straightforward name and address data quality issues in data integration projects. To extend data quality initiatives to all enterprise data, across all data types and all geographies, Informatica offers all Data Cleanse and Match Option customers an easy upgrade path to Informatica Data Quality.

This option features powerful, algorithmic data matching capabilities to identify relationships between data records for de-duplication or group-based processing. Drawing upon the data analysis and enhancement capabilities of Informatica Data Quality and the data integration capabilities of PowerCenter, this option lets you add data quality processes, to PowerCenter transformations. The option uses pre-built plans designed for address validation, standardization, and de-duplication to enhance the quality of your postal address data. Fully integrated within PowerCenter's architecture, the option's cleansing and matching capabilities automatically leverage PowerCenter's core strengths such as single development environment, performance, and universal data access.

Key Features

Data Cleansing and Parsing

• Standardizes, validates, enhances, and corrects customer contact (i.e., name/address) information and corporate or third-party data
• Isolates data and applies structure to each data element
• Enables data to be converted into different format, structure, and content to create the desired output record
• Works with Latin and non-Latin character sets such as Russian, Polish, Chinese, and Japanese
• Enables address information to be compared against postal service directories for the US and Canada

Data Matching

• Identifies relationships between data records for de-duplication or group-based processing
• Processes multiple sets of business rules concurrently

Full Integration Across Entire Data Integration Platform

• Leverages the PowerCenter architecture’s performance and scalability, automatically harnessing all of the platform’s sophisticated parallelization and grid capabilities when cleansing and matching data
• Leverages PowerCenter’s metadata management capabilities to deliver data lineage reports and audit
• Provides an easy upgrade path to Informatica Data Quality with its enterprise-wide data analysis, cleansing, matching, and monitoring capabilities

Benefits

Improve the Accuracy of Data
This option features rich parsing capabilities that allow data elements in customer files to be identified and separated into individual fields. The Data Cleanse and Match Option improves the accuracy of name and address data, giving end users confidence in the quality of their data and reducing mailing costs.

Increase Developer Productivity
Pre-built data quality plans, including plans for CASS-certified address validation and enhancement, reduce the development effort necessary to cleanse and transform data, improving developer productivity and reducing training requirements. Developers can take advantage of data cleansing and transformation tools directly from the PowerCenter toolbar, and data cleansing business rules write to and read from the single platform. Developers have access to reusable data cleansing specific transformations that they can use to both integrate and cleanse data in a single operation.

Maintain Enterprise-Wide Data Consistency and Integrity
One of the major problems associated with poor data quality is the duplication of data across similar records. This option helps IT teams identify and remove data duplication, which helps to ensure that data is consistent and accurate throughout the enterprise. Using powerful "fuzzy logic," existing records are searched for similar records using specific business-defined criteria. Match standards and business rules eliminate any doubt as to whether two records refer to the same individual customer or household. These functions simplify the creation of custom logic to perform this de-duplication process.

Product Literature

Cleanse and Match Option Datasheet
Data Quality Brochure
Data Quality White Paper
Informatica Data Quality datasheet
PowerCenter Brochure