View Course Agenda

Informatica Analyst, Data Discovery and Advanced Profiling 

Instructor Led | Data Quality | 3 Days | Version 10

Informatica Analyst, Data Discovery and Advanced Profiling

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.

Enroll Now

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
  • Data Analyst
  • Data Steward
  • Developer

Prerequisites

  • None

QUESTIONS?

Instructor Led | Data Quality | 3 Days | Version 10

Agenda

Informatica Analyst

Module 01: 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 02: 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 03: 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 04: Project Collaboration

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

Module 05: 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 06: 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.

Module 07: Rule Specifications

  • Convert business rules into Rule Specifications that can be applied to data.
  • Validate and Test the Rule Specification.
  • Compile the Rule Specification to create a Mapplet.
  • Review the Mapplet in the Developer Tool.
  • Lab: Create, Test and Compile a Rule Specification

Module 08: Task Management

  • Manage Exception Records.
  • Manually correct Bad/Exception Records and review the Audit Trail.
  • Consolidate Duplicate Records.
  • Review the Audit Trail.
  • Administer Tasks.
  • Lab: Manage Exception Records in the Analyst Tool.
  • Lab: Manage Duplicate Records in the Analyst Tool.
  • Lab: Administer Tasks.

Module 09: Scorecarding

  • Understand how to build and configure a Scorecard.
  • Apply Weightings.
  • Review Trend Charts.
  • Configure Notifications.
  • Lab: Create, Edit and Run a Scorecard.
  • Lab: Configure and Review Notifications.
  • Lab: Schedule Scorecards and Profiles to run using Informatica Administrator.

Data Discovery and Advanced Profiling

Module 1: Analyst Tool: Data Domain Discovery and Enterprise Discovery Profiling

  • Data Domain Profiling 
  • Inferring/identifying sensitive data 
  • Building and executing an Enterprise Discovery Profile 
  • Lab: Update a Profile to perform Data Domain Discovery
  • Lab: Create, execute and review an Enterprise Discovery Profile

Module 2: Developer Tool: Advanced Profiling

  • Varieties of Profiling 
  • Column and Enterprise Discovery Profiles 
  • Navigating an Enterprise Discovery Profile
  • Inference Options 
  • Join Analysis Profiling 
  • Lab: Create and navigate an Enterprise Discovery Profile 
  • Lab: Perform Join Analysis Profiling

Module 3: Developer Tool: Functional Dependency and Primary Key Inference

  • Object content and structure
  • Primary Keys
  • Functional Dependencies
  • Sensitive Data across all objects in the model 
  • Lab: Import and Profile a new set of data
  • Lab: Perform Functional Dependency and Primary Key Inference

Module 4: Developer Tool: Overlap Discovery and Foreign Key Profiling

  • Overlap Discovery between objects
  • Primary Key – Foreign Key relationships across objects
  • Verifying and Approving relationships
  • Generating DDL to create a new schema 
  • Lab: Overlap Discovery 
  • Lab: Primary Key – Foreign Key relationships

 
Enroll Now

Back to Course Overview


Print Friendly and PDF