EncartaLabs

Informatica Analyst

( Duration: 2 Days )

Informatica Analyst Tool allows for the analysis of data by creating projects, objects, profiling data, and identifying anomalies. In Informatica Analyst training course delegates will learn to use Analyst to understand relationships between tables and files, build Reference Tables and Scorecards, and manage Exceptions and Duplicate record tasks.

By attending Informatica Analyst workshop, delegates will learn 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

  • Business Analyst
  • Data Analyst

COURSE AGENDA

1

Data Quality Architecture and Data Objects

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

Profiling

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

Reference Table Management

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

Rule Specification

  • Converting business rules
  • Reference tables with rule specifications
5

Scorecards

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

Informatica Exception Management

  • Managing exception records
  • Consolidating duplicate records

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top