Tutorials on Informatica Data Quality idq

Introduction Informatica Data Quality is a suite of applications and components that you can integrate with Informatica Power Center to deliver enterprise-strength data quality capability in a wide range of scenarios. The core components are Data Quality Workbench and Data Quality Server. Informatica Data Quality is a suite of applications and components that you can integrate with Informatica PowerCenter to deliver enterprise-strength data quality capability in a wide range of scenarios. The core components are: Data Quality Workbench: Use to design, test, and deploy data quality processes, called plans. Workbench allows you to test and execute plans as needed, enabling rapid data investigation and testing of data quality methodologies. You can also deploy plans, as well as associated data and reference files, to other Data Quality machines. Plans are stored in a Data Quality repository. Workbench provides access to fifty database-based, file-based, and algorithmic data quality components that you can use to build plans. Data Quality Server: Use to enable plan and file sharing and to run plans in a networked environment. Data Quality Server supports networking through service domains and communicates with Workbench over TCP/IP. Data Quality Server allows multiple users to collaborate on data projects, speeding up the development and implementation of data quality solutions. You can install the following components alongside Workbench and Server. Integration Plug-In: Informatica plug-in enabling PowerCenter to run data quality plans for standardization, cleansing, and matching operations. The Integration plug-in is included in the Informatica Data Quality install fileset. Free Reference Data: Text-based dictionaries of common business and customer terms. Subscription-Based Reference Data: Databases, sourced from third parties, of deliverable postal addresses in a country or region. Pre-Built Data Quality Plans: Data quality plans built by Informatica. to perform out-ofthe- box cleansing, standardization, and matching operations. Informatica provides free demonstration plans. You can purchase pre-built plans for commercial use. Association Plug-In: Informatica plug-in enabling PowerCenter to identify matching data records from multiple Integration transformations and associate these records together for data consolidation purposes. Consolidation Plug-In: Informatica plug-in enabling Power Center to compare the linked records sent as output from an Association transformation and to create a single master record from these records. Informatica Algorithms Data Quality Workbench Matching Informatica offers several implementations of matching algorithms that can be used to identify possible duplicate records. Each implementation is based on determining the