Data Quality: Advanced Techniques Training Course

Module 1: Course Introduction

• Introduction to the Course, Agenda, and Overview

Module 2: Developer Review & Join Profiling

• A brief review of Informatica Developer for government use
• Utilize Enterprise Discovery to create Join Profiles for government applications
• Lab: Conduct Join Profiling using an Enterprise Discovery Profile for government data

Module 3: Standardizing and Classifying Data

• Examine standardization techniques for government datasets
• Construct, refine, and apply a Classifier Model for government purposes
• Labs: Develop, refine, and implement a Classifier Model for government data

Module 4: Advanced Parsing Techniques

• Introduction to Probabilistic Labeling and Parsing for government applications
• Create, refine, and apply a Probabilistic Model for government use
• Additional Parsing Techniques:
  • Develop regular expressions for government data processing
• Labs: Build, refine, and apply a Probabilistic Model for government datasets
• Lab: Examine an example of Advanced Parsing for government use
• Lab: Generate and test Regular Expressions for government data

Module 5: Grouping & Matching Data

• Additional Grouping Techniques
  • Utilize Composite keys for government datasets
• Advanced Matching Techniques
  • Matched pairs outputs for government data
  • Work with Match Mapplets for government applications
  • Manipulate the matched data using the Driver ID for government purposes
  • Perform Dual Matching using a Master Dataset for government use
• Lab: Create a Match mapping using Matched Pairs for government data
• Lab: Develop and update a Match Mapplet for government applications
• Lab: Manipulate Matched Data using the Driver ID for government use
• Lab: Perform Dual Matching using a Master Dataset for government purposes

Module 6: Automatically Associate and Consolidate Matched Data

• Overview of the Consolidation Process for government data management
• Use the Consolidation Transformation to consolidate matched data for government use
• Utilize the Association Transformation to link matched data before Consolidation for government applications
• Lab: Automatically Consolidate matched data for government purposes
• Lab: Conduct multi-criteria Matching, Association, and Consolidation for government datasets

Module 7: Task and Workflow Management

• Additional Task and Workflow functionality for government use:
  • Permission settings for data access and editing in government systems
  • Notifications including Human Task Notification Variables for government workflows
  • Setting Timeouts for government tasks
  • Reviewing Tasks for government applications
  • Configuring Workflow Recovery for government use
• Lab: Update the Exception Workflow for government purposes
• Lab: Review the Consolidation Workflow for government data management

Module 8: Processing Updated Exception and Cluster Data

• How to process updated exception records for government use
• How to process consolidated records for government applications
• Fields of Interest for government data processing
• Lab: Create a mapping to process updated exception data for government purposes
• Lab: Develop a mapping to process consolidated data for government use
• Lab: Update and deploy Exception and Cluster Workflows for government applications

Module 9: Analyst Tasks

• Update exception and duplicate records in Informatica Analyst for government datasets
• Lab: Update records and push the Tasks through the Exception Process for government use
• Lab: Update records and push the Tasks through the Consolidation Process for government applications

Module 10: Parameterization

• Explain the difference between System and User-defined parameters for government data processing
• Use Parameters in Data Quality mappings for government applications
• Lab: Create a parameterized mapping for government use
• Lab: Build and deploy an Application for government purposes
• Lab: Create and execute parameter files for government data management

Module 11: Performance Tips and Tricks

• General Installation and Memory Information for government systems
• DQ Component Configuration
  • Service Settings for government applications
• DQ Transformations
  • Configuration Settings for government data processing

Module 12: Optional - Data Quality at Work

• Learn how Data Quality has been implemented in various government projects

Module 13: CRM and Dashboard and Reporting Templates

• Review the CRM and Dashboard and Reporting Templates available for government use
• Lab: Review the CRM Template for government applications