• India Flag
    Call Us:

    +91 769-409-5404

  • USA Flag
    Call Us:

    +1 786-629-6893

About Course:

Informatica Data quality allows business users rapidly devlop business rules without relying on IT.It allows you to easily manage Exceptions for prompt remediations, and incorporate human tasks into your existing workflow.Data quality rules based on how similar data has been managed.It automatically detect data similarity.Which is the first step towards detecting and removing duplicate data.The role based self service interfaces enable collaboration between business stakeholders to optimize your entire data quality process.

Duration : 30 hours

Fee: 301

Job Trends

Who Should Learn?
  • Business Analysts.
  • Data Explorers.
  • Analytics Professionals.
  • Candidates interested in taking up career under Informatica.

To Learn Informatica IDQ you should have basic knowledge of SQL, especially functions, joins, sub queries etc.

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

Training Calender

Date Time Type Attend
No Schedule Available
Contact Us

+91 769-409-5404

  • 24 hours on-demand video
  • Articles
  • Coding Exercises
  • Full lifetime access
  • Certificate of Completion


Informatica Data Quality IDQ

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


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


  • What content is available with IDQ9?
  • Content Management Service
  • Accelerators
  • Core Accelerator


  • 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

Use Case

Use Case 1


Benefits of Certificate

Certification demonstrates your dedication, motivation and technical knowledge on a specific platform. Having a certification shows that you not only possess comprehensive knowledge of that technology but you also care enough about your own career to spend the time and money to get the certification.

We are welcoming our Students or professionals to participate in our professional online courses. We are offering great variety of online training programs and professional courses that you can always find as desired. After the completion of training program they will receive a certificate from BISP. As a Certified professional you can apply that knowledge in your future profession and enjoy with better salaries & career prospects.

Signup for free newsletter and
business tips

Any Questions?
Talk to our Course Co-ordinator

+91 769-409-5404
Want to see a live demo? We'll be in touch within 24 hours?