The course will introduce attendees to working with the Developer Tool, performing tasks such as creating projects and objects, profiling data and identifying anomalies.
You will develop cleansing and standardization routines
You can learn how to validate addresses using postal reference data
It will cover how to use different matching methods to identify duplicate records in a dataset and how to automatically and manually consolidate these duplicate records to create a master survivor record

What do you learn?

- Navigate through the Developer Tool
- Use Project Collaboration techniques such as shared Tags, Comments, Profiles, reference tables to share information with Analysts across projects
- Use a variety of profiling methods to profile data
- Use Analyst built profiles to develop mappings
- Build mappings and mapplets to cleanse and standardize data
- Perform Address Validation
- Identify duplicate records in a dataset
- Automatically and manually consolidate duplicate records to create a master record
- Execute mappings/mapplets in PowerCenter
- Use Data Quality Mappings in an Excel Spreadsheet

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 forworking 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 Ouputs
- 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

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

Content
- What content is available with IDQ9?
- Content Management Service
- How to configure AV information
- What are Accelerators?
- What comes with the Core Accelerator?

- Real Time Training
- Use cases for practice
- scenarios explanation
- Free software
- Installation
- Presentations
- Documentation
- Daily class recordings
- VMWare Image
- Resume preparation
- FAQ
- Certification