Data Quality: Advanced Techniques Training Course

Module 1: Course Introduction

• Course Introduction, Agenda, and Scope Overview

Module 2: Developer Review & Join Profiling

• Comprehensive Review of Informatica Developer
• Utilization of Enterprise Discovery for Join Profile Creation
• Practical Exercise: Execute Join Profiling via Enterprise Discovery Profiles

Module 3: Standardizing and Classifying Data

• Examination of Standardization Methodologies
• Development, Refinement, and Application of Classifier Models
• Practical Exercises: Construction, Optimization, and Deployment of Classifier Models

Module 4: Advanced Parsing Techniques

• Definition and Analysis of Probabilistic Labeling and Parsing
• Construction, Optimization, and Deployment of Probabilistic Models
• Supplementary Parsing Techniques:
  • Construction of Regular Expressions
• Practical Exercises: Development and Application of Probabilistic Models
• Practical Exercise: Evaluation of Advanced Parsing Scenarios
• Practical Exercise: Generation and Validation of Regular Expressions

Module 5: Grouping & Matching Data

• Extended Grouping Methodologies
  • Implementation of Composite Keys
• Advanced Matching Methodologies
  • Management of Matched Pairs Outputs
  • Operationalization of Match Mapplets
  • Modification of Matched Data via Driver ID
  • Execution of Dual Matching Processes
• Practical Exercise: Configuration of Match Mappings utilizing Matched Pairs
• Practical Exercise: Creation and Maintenance of Match Mapplets
• Practical Exercise: Manipulation of Matched Data using Driver ID
• Practical Exercise: Execution of Dual Matching against a Master Dataset

Module 6: Automatically Associate and Consolidate Matched Data

• Summary of the Consolidation Framework
• Implementation of the Consolidation Transformation for Data Aggregation
• Application of the Association Transformation to Pre-consolidate Data
• Practical Exercise: Automated Consolidation of Matched Records
• Practical Exercise: Execution of Multi-criteria Matching, Association, and Consolidation

Module 7: Task and Workflow Management

• Expanded Task and Workflow Capabilities:
  • Configuration of Access and Editing Permissions for Data
  • Notification Systems and Human Task Notification Variables
  • Configuration of Timeout Settings
  • Audit and Review of Tasks
  • Establishment of Workflow Recovery Mechanisms
• Practical Exercise: Modification of the Exception Workflow
• Practical Exercise: Analysis of the Consolidation Workflow

Module 8: Processing Updated Exception and Cluster Data

• Procedures for Processing Updated Exception Records
• Procedures for Processing Consolidated Records
• Identification of Critical Data Fields
• Practical Exercise: Creation of Mappings for Updated Exception Data
• Practical Exercise: Creation of Mappings for Consolidated Data
• Practical Exercise: Update and Deployment of Exception and Cluster Workflows

Module 9: Analyst Tasks

• Modification of Exception and Duplicate Records in Informatica Analyst
• Practical Exercise: Record Updates and Task Progression through Exception Processes
• Practical Exercise: Record Updates and Task Progression through Consolidation Processes

Module 10: Parameterization

• Differentiation between System-defined and User-defined Parameters
• Integration of Parameters within Data Quality Mappings
• Practical Exercise: Construction of Parameterized Mappings
• Practical Exercise: Development and Deployment of Applications
• Practical Exercise: Creation and Execution of Parameter Files

Module 11: Performance tips and tricks

• General Installation and Memory Allocation Information
• Data Quality Component Configuration
  • Service Level Settings
• Data Quality Transformations
  • Configuration Parameter Settings

Module 12: Optional - Data Quality at work

• Case Studies on Data Quality Implementation Across Various Projects

Module 13: CRM and Dashboard and Reporting Templates

• Assessment of Available CRM, Dashboard, and Reporting Templates
• Practical Exercise: Evaluation of the CRM Template