Data Quality: Advanced Techniques Training Course

Module 1: Course Introduction

• Introduction to the course, agenda, and overview

Module 2: Developer Review & Join Profiling

• Brief review of Informatica Developer for government use
• Create Join Profiles using Enterprise Discovery
• Lab: Perform Join Profiling with an Enterprise Discovery Profile

Module 3: Standardizing and Classifying Data

• Review standardization techniques for government data
• Build, refine, and apply a Classifier Model for government datasets
• Labs: Create, refine, and apply a Classifier Model to government data

Module 4: Advanced Parsing Techniques

• Understanding Probabilistic Labeling and Parsing in government contexts
• Build, refine, and apply a Probabilistic Model for government use
• Additional Parsing Techniques:
  • Create regular expressions for data parsing
• Labs: Build, refine, and apply a Probabilistic Model to government datasets
• Lab: Review an example of advanced parsing techniques in action
• Lab: Generate and test Regular Expressions for government data

Module 5: Grouping & Matching Data

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

Module 6: Automatically Associate and Consolidate Matched Data

• Overview of the consolidation process for government data
• Use the Consolidation Transformation to consolidate matched data for government use
• Use the Association Transformation to link matched data before consolidation in government applications
• Lab: Automatically consolidate matched data for government datasets
• Lab: Perform multi-criteria Matching, Association, and Consolidation for government use

Module 7: Task and Workflow Management

• Additional Task and Workflow functionality:
  • Set permission levels for data access and editing in government contexts
  • Manage notifications, including Human Task Notification Variables, for government use
  • Configure timeout settings for government workflows
  • Review tasks in government applications
  • Configure workflow recovery for government operations
• Lab: Update the Exception Workflow for government use
• Lab: Review the Consolidation Workflow in government contexts

Module 8: Processing Updated Exception and Cluster Data

• Process updated exception records for government operations
• Process consolidated records for government use
• Identify fields of interest for government data quality
• Lab: Create a mapping to process updated exception data in government contexts
• Lab: Create a mapping to process consolidated data for government applications
• Lab: Update and deploy Exception and Cluster Workflows for government use

Module 9: Analyst Tasks

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

Module 10: Parameterization

• Distinguish between System and User-defined parameters in government contexts
• Use parameters in Data Quality mappings for government data
• Lab: Create a parameterized mapping for government use
• Lab: Build and deploy an Application for government operations
• Lab: Create and execute parameter files for government datasets

Module 11: Performance Tips and Tricks

• General installation and memory information for government systems
• DQ Component Configuration:
  • Service settings for government data quality
• DQ Transformations:
  • Configuration settings for government data transformations

Module 12: Optional - Data Quality at Work

• Explore 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