View Course Agenda

Informatica Analyst 

onDemand | Data Quality | Self-Paced | Version 10

Informatica Analyst 

Course Overview

Informatica Analyst Tool allows for the analysis of data by creating projects, objects, profiling data, and identifying anomalies. Learn how to use Analyst to understand relationships between tables and files, build Reference Tables and Scorecards, and manage Exceptions and Duplicate record tasks.  This course is applicable to software version 10.

Enroll Now


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

  • Navigate through the Informatica Analyst tool 
  • Create projects and setting permissions 
  • Physical and Logical data objects 
  • Perform Column and Rule Profiling 
  • Apply rules in Mapping Specifications 
  • Create and manage reference tables 
  • Rule specifications 
  • Perform Scorecarding 
  • Task management 

Target Audience

  • Business Analyst
  • Data Analyst


Module 1: Data Quality Architecture and Data Objects 

  • Projects and project permissions 
  • Types of data objects in Informatica 
  • Importing flat files and relational tables 

Module 2: Profiling 

  • Introduction to profiling 
  • Column and Rule profiling in Informatica Analyst 
  • Building and mapping specification 
  • Rule profiling 

Module 3: Reference Table Management

  • Reference tables and importing flat files 
  • Managed and unmanaged reference tables 

Module 4: Rule Specification 

  • Converting business rules 
  • Reference tables with rule specifications 

Module 5: Scorecards

  • Scorecard and Pre-built rules 
  • Specifying valid column values

Module 6: Informatica Exception Management 

  • Managing exception records 
  • Consolidating duplicate records

Enroll Now

Back to Course Overview


onDemand | Data Quality | Self-Paced | Version 10

Print Friendly and PDF