BISP 

60% Complete Courses » Informatica Data Quality IDQ
  • Course Content
  • Course Overview
  • Training Schedule
  • Demo Video
  • Learning Material
  • Register


Topics covered include:
Profiling,scorecard,template preparation, Standardization and Address Validation
Matching and Consolidation Techniques.

Course Objectives:
On completion of this course Attendees 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


Course Agenda:

Introduction to Data Quality Management

Working with Informatica Developer 9
• 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 transformations
• 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 Mapplet

Matching
• Grouping data
• Analyze Detail Report
• DQ Matching
• Cluster Analysis Report
• Matching Mapplets

Labeling 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 IDQ9?
• Content Management Service
• Accelerators
• Core Accelerator

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

Course Id:
ETL006 
Course Fees:
301 USD