Informatica Data Quality Management for the Developer


Goal:
After successfully completing this course, students will be able to:
  • Describe the Data Quality Management Process
  • Illustrate the Data Quality Architecture
  • Differentiate between the Analyst and Developer Roles and Tools.
  • Navigate the Developer Tool
  • Collaborate on projects
  • Perform Column, Rule, Multi object, Comparative and Mid-Stream
  • Profiling
  • Manage Reference Tables
  • Develop standardization, cleansing and parsing Mappings and Mapplets
  • Identify duplicate records using Classic Data Matching
  • Create and execute Workflows to populate user inboxes with Exception and Duplicate record tasks
  • Describe the deployment options available when executing Mappings outside of Informatica Developer
  • Troubleshoot issues that may appear during development


Target audience:
Developers

Description:
Gain the skills and knowledge necessary to implement and automate a data quality assurance process with the Informatica Data Quality platform. In addition, learn how to cleanse, standardize, and enhance data, students will learn to test and troubleshoot their Data Quality solutions.

Content:

Module 1: Course Introduction

  • Course topics
  • Modules and content

Module 2: Data Quality Process Overview

  • Data Quality Management Process Cycle
  • Dimensions of Data Quality
  • Data Quality Processes
  • Developer and Analyst Roles and Tools
  • Data Quality Architecture

Module 3: Data Quality Projects and Solutions

  • Customer Data Quality Use Cases
  • Projects that benefit from cleansed and standardized data
  • Data Quality and typical DI/DQ projects
  • Reporting, Gating and Cleansing projects
  • Solution Architecture for Projects with Data Quality

Module 4: Project Collaboration and Reference Table Management

  • Developer Interface
  • Understanding Analyst projects, Data Objects, Profiles, Rules, Scorecards, Comments and Tags
  • Reference Tables and the Data Quality Process
  • Creating Reference Tables
  • Labs

Module 5: Working in the Developer Tool

  • Tasks in the Developer Tool
  • Working with Physical and Logical Data Objects
  • Connecting to a table
  • Importing and flat file
  • Creating logical data objects
  • Developer Transformations
  • Mappings and mapplets
  • Content sets and their uses
  • Developer Tips and Tricks
  • Labs

Module 6: Profiling, Mapplets and Rules

  • Column Profiling
  • Mapplets and Scorecards
  • Profiling techniques to debug and improve development
  • Updating Scorecards with Rules
  • Labs

Module 7: Standardizing, Cleansing and Enhancing Data

  • Standardizing, cleansing and enhancing data.
  • Mappings that cleanse, standardize and enhance data
  • Developing standardization mapplets
  • Configuring standardization transformations
  • Labs

Module 8: Parsing Data

  • The Parsing Process
  • Parsing techniques
  • Key parsing transformations
  • Labs

Module 9: Matching Data

  • Match Data definition
  • The DQ matching process
  • The different stages of Matching
  • Grouping and its effect on matching
  • Grouping methods
  • Grouping results and refining a grouping strategy
  • Match algorithms
  • Labs

Module 10: Manual Exception and Consolidation Management

  • Exception and Duplicate record management
  • Exception Management Process.
  • Populating tables with exception and duplicate record tasks
  • Labs

Module 11: Building, Managing and Deploying Workflows

  • Workflows and Workflow Tasks
  • Human Tasks and Steps
  • Identifying exception and duplicate records
  • Deploying and executing workflows
  • Verifying Tasks in Informatica Analyst.
  • Labs

Module 12: Deploying: Executing Mappings outside of the Developer tool

  • Deployment options
  • Mappings as applications
  • Scheduling mappings, profiles and Scorecards
  • Labs

Module 13: Importing and Exporting Project Objects

  • Export/import project use cases
  • Basic and Advanced Import options
  • Exporting a project
  • Labs

Module 14: Troubleshooting

  • Common Developer errors
  • Common Mapping and Transformation configuration issues
  • Common Workflow configuration errors
  • Tips for working with the Developer tool
  • Labs


General information:

GENERAL

The course is taught in local language, the course material is written in English. Course includes plenty of hands-on exercises.

Course price includes course material and catering (coffees, lunch) daily.

Affecto reserves the right to make changes to courses and schedules. Affecto may cancel a course if there are less than six (6) participants. Affecto is not responsible for any expenses related to course cancellation.

This course can also be arranged onsite at customer location.

FINLAND
The course will be held Affecto Academy training facility at Atomitie 2, 00370 Helsinki. The course day begins at 9am and end at 4pm.

VAT will be added to the prices.

For more information, please contact Academy Finland

NORWAY
The course will be held Affecto Academy training facility at Stortorvet 10 (GlasMagasinet), Oslo. The course day begins at 9am and end at 4pm.

For more information, please contact Academy Norway

SWEDEN
The course will be held at either Affecto Academys training facility at Holländargatan 17B, 111 60 Stockholm or at an external training facility in Stockholm depending on the number of participants. The course day begins at 9am and end at 4pm.

VAT will be added to the prices.

For more information, please contact Academy Sweden



Duration: 4 day
Price: 2800.00 €

Register:
17.04.2018, Affecto Finland

Cancellation and payment terms
Request offer
Print
Good to know
Contact
Calendar