Informatica Analyst (INFA)(10)

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.
 
Objectives
After successfully completing this course, participants 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
  • Data Analyst
  • Business Analyst
 
Prerequisites
None
 
Show details
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