View Course Agenda

Informatica Analyst 

onDemand | Analyst | Self-Paced

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 Anaylst 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

Objectives

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


Agenda

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


QUESTIONS?

onDemand | Analyst | Self-Paced | Version 10

Print Friendly and PDF