Informatica Analyst, Data Discovery and Advanced Profiling

Instructor Led | Data Quality | 3 Days | Version 10

Course Overview

This course is applicable to software versions 10x. Learn to use Informatica Analyst and Developer tools to create projects and objects, profile data, and identify anomalies in order to develop a better understanding of data sets. Discover the content and structure of data through topics such as Data Domain Discovery and Enterprise Discovery Profiling including; Join Analysis, Functional Dependency Profiling, Primary Key Inference, Overlap Discovery and Foreign Key Profiling.

Objectives

After successfully completing this course, students should be able to:

Navigate through the Informatica Analyst tool.
Create projects and assign permissions.
Work with Physical and Logical data objects.
Perform Column Profiling
Create and apply Rules to profiles
Create and manage Reference Tables
Build a Rule Specification
Manage Exception and Duplicate Record Tasks
Perform Scorecarding
Task management
Apply Data Domain Discovery to profiles in the Analyst Tool
Build and execute an Enterprise Discovery Profile in the Analyst Tool
Define the different types of Profiling that are available in the Developer Tool
Create and execute Enterprise Discovery Profiles in the Developer Tool
Perform Data Domain Discovery and Join Analysis Profiling
Perform Functional Dependency and Primary Key Inference
Perform Overlap Discovery and Foreign Key Profiling
Update the model with Primary and Foreign Key relationships
Generate DDL from the updated model

Target Audience

Business Analyst
Developer
Data Analyst
Data Steward

Prerequisites

None

Agenda

Informatica Analyst

Module 1: Introduction to Data Quality

Define Data Quality Management.
Explain the Data Quality Process.
Discuss Informatica’s Data Quality Architecture.
Navigate the Analyst Interface.
Create Projects and Assign Permissions.
Lab: Create a Project and Assign Permissions.

Module 2: Data Objects

Understand the types of Data Objects that exist in Informatica 10.
Import Flat Files and create connections to Relational Tables.
Build a Mapping Specification.
Lab: Create a variety of Data Objects.
Lab: Create a Mapping Specification.

Module 3: Analyst Profiling

Introduction to Profiling.
Perform Column Profiling in Informatica Analyst.

Interpret Profile Results using Summary and Detail view.
Edit Profiles.
Detect Outliers
Review and Compare Historical Profile Results
Schedule Profiles.

Lab: Create profiles, detect outliers and review profile results

Module 4: Project Collaboration

Collaborate with team members using shared Projects, Comments, Bookmarks and Data Exports.
Lab: Add Comments to Profiles and Export Profile Results.

Module 5: Rules

Perform Rule Profiling in Informatica Analyst.

Apply Prebuilt and Custom Rules.
Interpret Rule Results.

Lab: Apply Prebuilt and Custom Rules to Profiles.
Lab: Apply Rules to a Mapping Specification.

Module 6: Reference Table Management

Create Reference Tables using the Reference Table Editor and the Import Flat Files options.
Create Managed and Unmanaged Reference Tables.
Auditing of changes.
Lab: Create Reference Tables using a variety of methods.