Online Informatica IDQ - Data Quality Training :

Informatica Data Quality Online Training Course Content:
Informatica Analyst 9
* Analyst GUI
* Metadata and Data access/import
* Column Profiling
* Frequency/Patterns/Statistics/Drill downs
* Rule Profiling
* Out Of The Box rules
* Custom rules
* Reference Tables Management
* Project Collaboration
* Data Quality Scorecarding

Informatica Developer 9
* Developer GUI
* Developer Profiling including:
* Mid-stream profiling
* Join analysis profiling
* Building Data Quality Mapplets and Rules
* Data Standardization
* Cleanse, transform and parse data using DQ transformations such as the Case Converter, Merge, Labeller,
Standardizer, Parser
* Address Validation
* Perform address validation and create AV mapplets and mappings
* Matching
* Group data prior to matching to improve matching performance
* Perform DQ and Identity Matching to identify duplicate records
* Develop Matching Mapplets
* Associate and Consolidate matched data
* Work with the Data Quality Assistant
* PowerCenter Integration
* Parameterization
* Data Quality Workshop

1) Association/Consolidation Transformation
a) Application and usage of the transformation to eliminate duplicates
b) Using different strategies in Consolidation transformation
c) Advanced Consolidation transformation usage and Row based

2) Address Validator Transformation
a) Configuring AV transformation using the CMS
b) Setting the properties in AD50.cfg file
c) End to End scenario featuring the AV transformation

3) Match Transformation
a) Configuring the Keygen transformation and Match
b) Understanding the various strategies as a part of the classic Match transformation
c) Setting the SSAPR and initializing IMO (Identity Match transformation)

4) Exception Transformation
a) Configuring Bad Record/Consolidation exception transformation
b) Editing the DQA tables as a part of the Analyst tool
c) Recycling records using Exception transformation

5) Usage of All Data Quality Transformations in a customer scenario

6) Example of an All DQ Mapping with optimized results

Know About  Informatica Online Training Courses.