Informatica Data Quality Certification Training

One of the top providers of online IT training worldwide is VISWA Online Trainings. To assist beginners and working professionals in achieving their career objectives and taking advantage of our best services, We provide a wide range of courses and online training.

4627 Reviews 4.9

Learners : 1080

Duration :  25 Days

About Course

Leading industry specialists with practical project experience are providing our IDQ training. From fundamental to advanced topics, including working with Informatica, developer profiling, analyst collaboration, address matching, validation, transformation, mapping, and data standardization, as well as practical experience with the integration of Power Centre, are all covered in our course curriculum. You can get all the skills necessary for significant professional progress in IDQ technology during the IDQ course.

Informatica Data Quality Training Course Syllabus

Unit 1: Working with Informatica Developer 9

✔ GUI, Mappings, Mapplets, Transformations, Content Sets, Data Objects

Unit 2: Analyst Collaboration

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

Unit 3: Developer Profiling

✔ Join Analysis Profiling
✔ Column Profiling
✔ Multi-Object Profiling
✔ Mappings and transformations
✔ Mid-stream profiling
✔ Comparative profiling
✔ Scorecard creation and automation

Unit 4: Data Standardization in Informatica Data Quality

✔ Cleanse, transform and parse data
✔ Develop data standardization mapplets and mappings

Unit 5: Address Validation

✔ Reusable AV Transformation
✔ AV Transformation Properties
✔ AV Inputs and Outputs
✔ Reusable AV Mapplet

Unit 6: Matching in Informatica Data Quality

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

Unit 7: Labeling and parsing the data
Unit 8: Different use cases
Unit 9: Consolidation

✔ Associate and Consolidate data

Unit 10: Human task Automation
Unit 11: Data Quality Assistant

✔ Build Mappings to create and populate the DQA tables
✔ Perform manual Consolidation and Bad Record Management

Unit 12: PowerCenter Integration

✔ Run DQ Mappings in PowerCenter

Unit 13: Object Import/Export

✔ Import Projects using both Basic and Advanced methods
✔ Export Projects

Unit 14: Parameters in Informatica Data Quality

✔ How to use Parameters in Data Quality mappings, transformations, and reference tables

Unit 15: Rule specifications
Unit 16: Automation of jobs, profiles, and scorecards
Unit 17: Content

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


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

Live Instructor Based Training With Software
Lifetime access and 24×7 support
Certification Oriented content
Hands-On complete Real-time training
Get a certificate on course completion
Flexible Schedules
Live Recorded Videos Access
Study Material Provided

Informatica Data Quality Training - Upcoming Batches

7th NOV 2022



Coming Soon



5th NOV 2022



Coming Soon



Don't find suitable time ?


Live Virtual Training

  • Schedule your sessions at your comfortable timings.
  • Instructor-led training, Real-time projects
  • Certification Guidance.

Self-Paced Learning

  • Complete set of live-online training sessions recorded videos.
  • Learn technology at your own pace.
  • Get access for lifetime.

Corporate Training

  • Learn As A Full Day Schedule With Discussions, Exercises,
  • Practical Use Cases
  • Design Your Own Syllabus Based
For Business

Informatica Data Quality Online Training FAQ'S

What do you know about IDQ? Give a brief idea about the core components in IDQ?

IDQ refers to Informatica Data Quality which is a tool used by data analysts to deploy the data quality for all different kinds of workloads. IDQ integrates with Informatica Power center to ensure that data quality is delivered. IDQ is specifically designed to perform functionalities like data matching, cleansing, and profiling.

IDQ includes two core components that are listed below:

Data quality workbench: The data quality workbench is the component that performs data analysis and creates the rules accordingly for data enrichment and standardization.

Data quality server: The Data Quality Server is used to run the programs, file sharing, and accomplish the plans in a networked environment. It also supports networking through different domains and communicates with workbench over TCP/IP.

Give a brief idea about connected lookup and unconnected lookup?

Connected Lookup: The connected lookup is a lookup that is capable of participating in all the workflows and receives the inputs from other transformations directly. Connected lookup is used in both static and dynamic cache, supporting user-defined values.

Unconnected Lookup: Unconnected lookup is capable of receiving the inputs based on the last known position. It returns only one column value. Unconnected lookup is not capable of supporting user-defined values.

Get ahead in your career by learning IDQ through VISWA Online Trainings

What do you understand by the terms: predefined event and user-defined event?

A predefined event states that the event is predefined. It is likely to be a file-watch event. A predefined event waits for a particular file to arrive at a specific location.

A user-defined event is a collection or flow of the tasks to be performed in the workflow process. The user-defined events are created and utilized based on the requirement.

What do you understand by an Address Doctor in Informatica IDQ?

Address Doctor in IDQ is a transformation primarily used to compare the input address data with the reference data. It is designed to determine the accuracy of the input address and relatively fixes the errors in those addresses. It is the validator transformation available to rectify and make the necessary changes to the data as per the business requirements. 

What is the use of standalone command task?

The standalone command task could be used to execute shell commands anywhere in the workflow process.


Vishnu Gadipudi
Vishnu Gadipudi
I Enrolled in VISWA Online Trainings for IBM Integration BUS course . Recently I Completed IBM Integration BUS Batch. It was Really Awesome Experience. Best Place To Learn , Experienced Trainer, Gives Us High Level Knowledge....
Navya Biradavolu
Navya Biradavolu
I was enrolled for looker Bl Tool,it was amazing experience . especially soft skill batch is one of my favourite batch . overall learning process is quite impressive.
Indla sneha
Indla sneha
I have joined I have joined VISWA Online TRAININGS for Java full stack course and i have completed Advance Java module. I had a good knowledge of Hibernate, spring,spring boot,spring MVC. Tutor has knowledge in depth and is supportive. Srinadh sir solved all our doubts....
bindu hima
bindu hima
I am recently completed Talend course and trainer is Rajendra very professional and helpful. All the doubts were solved in a precise manner.
Tarunasree Gowra
Tarunasree Gowra
"I truly enjoyed this course." Chaitanya sir fantastic-very knowledgeable. Sir give us very informative and clear instruction on how to achieve the goal. Thank you!
Tejaswini Kommu
Tejaswini Kommu
Overall Linux Admin sessions batch was very good. Mr. RAM Krishna teaching was very helpful to remind our basic concepts in linux & networking.
Gopanaboina Mounika
Gopanaboina Mounika
It was great learning with such a great and experienced staff. Praveen Sir (Oracle EPM Cloud - FCCS) was very helpful and operations team also very helpful in solving any minor problems students go through process.
Jyothi Gutlapalli
Jyothi Gutlapalli
I like to share my experience which provide lots of courses and one of those I recently completed my Salesforce BA Course and I like to tell you it was a great experience and my knowledge and confidence is really boosted after completing this course.
Good experience and great learning platform for Hyperion Essbase and Planning. The faculty is also well trained and soft spoken.
Chaitu Viswa
Chaitu Viswa
It was very good session for QlikView. I would like to thank to teacher Mr.Chandu for providing guidance for the required modules. Thanks VISWA Team for giving apportunity to leran new skills.

Quick Links