Topics covered include: Profiling,scorecard,template preparation, Standardization and Address Validation Matching and Consolidation Techniques.
Course Objectives: On completion of this course Attendees 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
Introduction to 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 transformations • 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