Informatica Course


Course Overview

Informatica Power Center supports every one of the means of Extraction, Transformation and Load process/life cycle. There are other (outsider) products which are offered and made around the Power Center’s capacity to associate with various innovations running. Informatica Power Center is a simple to utilize GUI based instrument. It has a basic visual interface which is straightforward and use. Every one of the segments are intended to be utilized by a basic simplified component for various articles like source, targets, changes, mapplets, mappings, sessions, worklets and work processes which add to the structure procedure stream of the information extraction, change and burden

The tool’s ability to fetch/transform and load huge volumes of data in a very effective way, with less resource consumption is better.

Informatica Power Center is a widely used extraction, transformation and loading (ETL) tool used in building enterprise data warehouses. The components within Informatica PowerCenter aid in extracting data from its source, transforming it as per business requirements and loading it into a target data warehouse.

This course is designed for the absolute beginner, developers, and database analysts, Analytics Professionals, BI/ETL/DW Professionals, Mainframe Developers and Architects, Enterprise Business Intelligence. Anyone interested to change career into informatica database management.

Individual must have some Knowledge of basic SQL and Basic UNIX Commands.

You can become an ETL developer or administrator in major IT companies like Infosys, Wipro, Genpact, Cyient and many other companies.

The course main topics are Introduction, Designer Overview, Creating and debugging a mapping, Transformation Objects in Depth, Working with Flat Files, Using the Debugger and more concepts.

Informatica Course Syllabus

Course Introduction

  • Course Objectives
  • Introduction to Informatica Power Center
  • Components & Architecture

Designer Overview

  • Interface
  • Tools

Creating and debugging a mapping


  • Mappings
  • Sources and Targets
  • Transformations Objects

Transformation Objects in Depth I

  • Source Qualifier
  • Expression
  • Filter
  • Aggregator
  • Target Instance
  • Lookup

Working with Flat Files

  • Importing & editing flat file sources & targets
  • Flat file data-types

Using the Debugger

  • Debugging process and strategies
  • Breakpoints, evaluate expressions

Designer Tips

  • Documenting objects
  • Context Sensitive Help, Auto link, Link Path

Transformation Objects in Depth II

  • Stored Procedure, Router, Sorter

Local Variables

  • Using local variables
  • Port evaluation

Transformation Objects in Depth III

  • Rank, Joiner


  • Built-In Functions
  • User-Defined Functions

Designer: Propagate attributes

Sharing and Reusing Designer Objects

  • Reusable transformations
  • Working with shortcuts

Transformation Objects in Depth IV

  • Union, Normalizer, Java Transformation, SQL Transformation, HTTP Transformation, Transaction Control


  • Designer: Foreign Key Relationships
  • Transformation Objects in Depth V
  • Update Strategy, Sequence Generator

Slowly-Changing Dimensions

Workflow Manager

  • Menus & tools
  • 5 steps to creating a workflow
  • Session properties

Workflow Monitor

  • Interface
  • Controlling workflows and tasks
  • Viewing logs & session properties
  • Gantt Chart View & Task View

Workflow Tasks

  • Command, Email, Decision, Timer, Control, Event Raise & Wait


  • Parameters & Variables
  • In mappings
  • In sessions and workflows
  • Parameter files