Informatica Data Quality IDQ web based Online Training Curriculum

Course Objective

On completion of training course trainee will be able to:

• Navigate the Developer Tool and collaborate on projects with Analysts using the Analyst Tool
• Perform Column, Rule, Join, Multi object and Mid-Stream Profiling
• Manage reference tables in the Analyst Tool
• Design and develop Mapplets
• Create standardization, cleansing and parsing routines
• Validate addresses
• Identify duplicate records
• Build mappings used to associate and consolidate matched records

Introduction to Informatica Data Quality

• Data Quality Management
• Working with Informatica Developer latest version
• GUI
• Mappings
• Mapplets
• Transformations
• Content Sets
• Data Objects

Analyst Collaboration

• Reviewing information from the Analyst
• Comments/Tags
• Creating/adding to Reference tables

Developer Profiling

• Join Analysis Profiling
• Column Profiling
• Multi Object Profiling

Mappings and Transformation

• Mid-stream profiling
• Comparative profiling

Data Standardization

• Cleanse, transform and parse data
• Develop data standardization Mapplets and mappings

Address Validation

• Reusable AV Transformation
• AV Transformation Properties
• AV Inputs and Outputs
• Reusable AV Mapplets
• Matching
• Grouping data
• Analyze Detail Report

DQ Matching

• Cluster Analysis Report
• Matching Mapplets

Labelling and parsing the Data

• Different use cases
• Consolidation
• Associate and Consolidate data
• Data Quality Assistant
• Build Mappings to create and populate the DQA tables
• Perform manual Consolidation and Bad Record Management

PowerCenter Integration

• Run DQ Mappings in PowerCenter
• Object Import/Export
• Import Projects using both Basic and Advanced methods
• Export Projects
• Parameters
• How to use Parameters in Data Quality mappings, transformations and reference tables?

Content

• What content is available with IDQ latest version?
• Content Management Service
• Accelerators
• Core Accelerator

Project

• Use all that has been covered and apply it to Product Data

Topics covered include

• Profiling
• Scorecard
• Template preparation
• Standardization and Address Validation
• Matching and Consolidation Techniques

Delivery Methodology

• We are using an experiential delivering methodology that blends theoretical concepts with hands-on practical learning to ensure a holistic understanding of the subject or course

Class Delivery

• Live Interactive classes with expert