Informatica Data Quality 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 Score carding

1.Informatica Developer9

• 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, Labeler,Standardize, 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
• Power Center Integration
• Parameterization Data Quality Workshop

2.Association/Consolidation Trasformation

• Application and usage of the transformation to eliminate duplicates
• Using different strategies in Consolidation transformation
• Advanced Consolidation transformation usage and Row base

3.Address Validation Transformation

• Configuring AV transformation using the CMS
• Setting the properties in AD50.cfg file
• End to End scenario featuring the AV transformation

4.Match Transformation

• Configuring the Key gen transformation and Match
• Understanding the various strategies as a part of the classic Match transformation
• Setting the SSAPR and initializing IMO (Identity Match transformation)

5.Exception Transformation

• Configuring Bad Record/Consolidation exception transformation
• Editing the DQA tables as a part of the Analyst tool
• Recycling records using Exception transformation