Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Informatica Data Quality v9.x Online Training

No Reviews Yet

Course type: Online Instructor led Course

Platform: GoToMeeting

Course ID: 28462

Course type: Online Instructor led Course

Platform: GoToMeeting

Raj picture
No Reviews Yet

Date and Time

Not decided yet.

Raj picture

Informatica & Oracle Certified Professional

About Raj

Expert in ETL, Data Integration, Data Quality & Metadata Management
No reviews currently

About the Course

Developed by Informatica Corporation, Informatica Data Quality is a unique kind of Data Quality Management System featuring a suite of applications and components that can integrate well with Informatica PowerCenter. The objective of this platform is to deliver enterprise-strength Data Quality ability across a large number of scenarios. One of the principal advantages of this system is the possibility to solve quality problems in a way achieving real as well as sustainable data quality enhancements. A quality training in Informatica Data Quality can enable candidates proactively monitor and cleanse the data and assist the business in Data Quality and Governance.

Duration:: 25 Hours

* Fully licensed software (Installation & Configuration)
* Lifelong subscription to our Google group "ETL Central"
* Assistance in Resume Building
* Job Oriented Training
* Deployment of DQ mappings into PowerCenter and their business use cases

::Session Timings::
** Weekday Batches: (Mon - Sat)
Any one hour in the below mentioned timings as per the slot availability
Morning Hours: 05:00 AM - 10:00 AM IST
Evening Hours: 10:30 PM - 11:30 PM IST

** Weekend Batches: (Sat & Sun)
Two sessions (each 2 hours) per day both on Sat & Sun

***Course Fee***
* With Licensed Software: Rs.15000/-
* Without Licensed Software: Rs.12000/-

Topics Covered

An Overview of Informatica Developer 9
Overview of Data Quality and Informatica Developer covering areas such as the GUI, Mappings, Mapplets, Transformations, Content Sets, Data Objects and Tips for working with Developer.

**Analyst Collaboration
- Review Information from the Analyst
- Profiles/Comments/Tags
- Create/Add to Reference Tables
- Shared projects and team collaboration means no loss of information or duplication of work across projects

**Developer Profiling
- Perform Join Analysis Profiling
- Perform Column Profiling
- Multi Object Profiling
- Build and execute a Mapping using core transformations
- Configure Transformation Properties

**Data Standardization
- Develop data standardization mapplets and mappings
- Cleanse, transform and parse data
- Data Quality cleansing and parsing transformations

**Address Validation
- Configuring a Reusable AV Transformation
- AV Transformation Properties
- AV Inputs and Outputs
- Define a Reusable AV Mapplet
- Build and address validation mapping to incorporate your mapplet Matching
- Grouping Data
- Key Generator Transformation
- Key Gen Methods and Properties
- Analyze Detail Report
- DQ Matching
- Perform matching using the Match Transformation
- Match Properties
- Matching Algorithms
- Cluster Analysis Report
- Create and update matching Mapplets
- Additional Matching Transformations

**Identity Matching
- Build matching mappings using Identity Matching
- Identity Populations and Strategies

**Automatic Consolidation
- Automatically associate and consolidate your match data using a variety of association and consolidation 
- Transformations and techniques

**Manual Consolidation Using the Data Quality Assistant
- Build mappings to create and populate the DQA tables using the new Exception Transformation
- Perform Manual consolidation and bad record management using the DQA

**PowerCenter Integration
- Execute Data Quality mappings/mapplets in PowerCenter

**Object Import/Export
- Learn how to export and import projects using both basic and advanced methods

**DQ for Excel
- Run Data Quality mappings on Excel spreadsheets

-How to use parameters in Data Quality mappings, transformations and reference tables

- Content availability with IDQ9
- Content Management Service
- How to configure AV information
- Accelerators
- Core Accelerator

Who should attend

Wanna be DQ Developers/Analysts and any DQ Enthusiasts.


* Fundamentals of ETL knowledge is recommended to have
* Good internet connectivity (min 512kbps)

What you need to bring

Regular practice of topics covered is what expected at the least for every next class"

Key Takeaways

* Understanding the concepts of Data Quality
* Troubleshooting errors/failures
* Gain hands-on experience with multiple exercises and various real time scenarios
* Build confidence to excel your career as an efficient Informatica DataQuality Developer/Analyst


No reviews currently


Post your requirement and let us connect you with best possible matches for Informatica Training Post your requirement now