Written by SRonline  

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