BISP 

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


Informatica data Quality online Training and job support | Best Online learning material for Informatica data Quality IDQ training and certification|BISP

Informatica Data Quality IDQ online training and video tutorial

INFORMATICA DATA QUALITY(IDQ) Online Training

Course Objectives:

On completion of this 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

Course Agenda:

Introduction to Informatica Data Quality

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

Topics covered include:

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

Course Duration:25-30 Hours

Course Id:
ETL006 
Course Fees:
301 USD