INFORMATICA - Online Training for SAP|Oracle|JAVA|Microsoft|Mobile Apps|Testing|SAS|Hadoop - Acutesoft Solutions
India:+91 (0)8885575549, 040-42627705 | USA: +1 973-619-0109 | UK: +44 207-993-2319







Download [PDF]

  • Data Warehouse Concepts
      Introduction to Data warehouse
      What is Data warehouse and why we need Data warehouse
      OLTP vs ODS vs Data warehouse
      Dimensional modeling
      Star schema/Snowflake schema/Galaxy schema
      Dimensions / Facts tables
      Slowly Changing Dimensions and its types
      Data Staging Area
      Different types of Dimensions and Facts
      Data Mart vs Data warehouse
      DWH Approaches: Ralph Kimball’s vs Bill Inmon’s
  • Informatica Power Center
      Software Installation
      Informatica 9 Server/Client Installation on Windows
  • Power Center Architecture and Components
      Introduction to informatica Power Center
      Difference Between Power Center and Power Mart
      PowerCenter 9 architecture
      PowerCenter 7 architecture vs PowerCenter 8 and 9 architecture
      Extraction, Transformation and loading process
      Power Center tools: Designer, Workflow manager, Workflow Monitor, Repository Manager, Informatica Adminstration Console.
      Repository Server
      Repository maintenance
      Repository Server Administration Console
      Security, Repository, privileges and folder permissions
      Metadata extensions
  • Power Center Developer Topics
      Create a Folder
      How to provide Previllages
      Source Object Definitions
  • Source types
      Relational Tables (Oracle, Teradata)
      Flat Files (fixe width, Delimiter Files)
      Xml Files
  • Source properties
  • Analyze Source Data, Import Source
  • Target Object Definitions
      Target types
      Target properties
  • Import Targets
      Transformation Concepts
      Transformation types and views
      Transformation features and ports
      Informatica functions and data types
  • Mappings
      Mapping components
      Source Qualifier transformation
      Pre SQL and Post SQL
      Mapping validation
      Data flow rules
  • Create a Mapping, session, and workflow
      Workflow Tools
      Workflow Structure and configuration
      Workflow Tasks
      Workflow Design and properties
  • Session Tasks
      Session Task properties
      Session components
      Transformation overrides
      Session partitions
  • Workflow Monitoring
      Workflow Monitor views
      Monitoring a Server
      Actions initiated from the workflow Monitor
      Gantt chart View and Task view.
  • Start and Monitor a Workflow
      Debugger features
      Debugger windows
      Tips for using the Debugger
  • The Debugger
      Expression transformation
      Expression, variable ports, storing previous record values.
      Different type of Ports
      Input/ output / Variable ports and Port Evaluation
      Filter transformation
      Filter properties
  • Expression and Filter
      Aggregator transformation
      Aggregation function and expressions
      Aggregator properties
      Using sorted data
      Incremental Aggregation
  • Joiner transformation
      Joiner types
      Joiner conditions and properties
      Joiner usage and Nested joins
  • Aggregator, Heterogeneous join
  • Working with Flat files
  • Importing and editing flat file sources & Targets
  • Lab Session – Use Flat file as source. Sorter transformation
  • Sorter properties
      Sorter limitations
  • Sorter
      Propagate Attributes.
      Shared Folder and Working with shortcuts.
      Informatica built in functions.
  • Lookup transformation
      Lookup principles
      Lookup properties
      Lookup techniques
      Connected and unconnected lookups, Lookup Caches
  • Basic and Advance Lookup Target options
      Row type indicators
      Row loading operations
      Constraint- based loading
      Rejected row handling options
  • Deleting Rows
      Update Strategy transformation
      Update strategy expressions
    1. Data Driven Inserts and Rejects
      Router transformation
      Using a router
      Router groups
  • Router Conditional Lookups
      Usage and techniques
  • Straight Load
  • Conditional Lookups
      Heterogeneous Targets
      Heterogeneous target types
      Target type conversions and limitations
  • Heterogeneous Targets Mapplets
      Functionality and Advantages
      Mapplet types and structure
      Mapplet limitations
  • Mapplets
      Reusable transformations
      Promoting and copying transformations
  • Reusable transformations /Sequence Generator transformation
      Using a sequence Generator
      Sequence Generator properties
      Dynamic Lookup
      Dynamic lookup theory
      Usage and functionality
  • Dynamic Lookup Concurrent and sequential Workflows
      Concurrent Workflows
      Sequential Workflows
      Stopping, Starting and suspending tasks and workflows
  • Sequential Workflow Additional Transformations
      Union Transformation
      Rank transformation
      Normalizer transformation
      Custom Transformation
      Transformation Control transformation
      XML Transformation
      SQL Transformation
      Stored Procedure Transformation
      External procedure Transformation
      SQL Transformation
  • Lab Sessions- For above transformations Error Handling
      Overview of Error Handling Topics
      Review various BI Reporting methods
      Informatica – Best practices
      Mapping Design through Visio tool
      Data Loading techniques for huge volume of data
      XML Data Loading – Best Practices
      Incremental Loading and Rollback procedures
      Slowly changing dimension – Overview
      Caching VS Direct load
      Transaction Handling
      Performance Tuning
      Traceability and Event Logging
  • Error handling fatal and non Fatal Workflow Tasks
      Even Raise and Wait
      Sequential Batch Processing
      Parallel Batch Processing
  • Lab Sessions – With Workflow tasks Link Conditions Team Based Development
      Version Control
      Checking out and checking in objects
      Performance Tuning
      Overview of System Environment Identifying Bottlenecks
      Optimizing Source, Target, mapping, Transformation, session
      Mapping Parameters and Variables
  • Introduction to Mappng Variables and Parameters
  • Creating Mapping Variables and Updating Variables
  • Creating Parameter File and associating file to a Session
  • System Variables
  • Variables functions
  • Override Mapping Variable with Parameter Files
  • Dynamically Updating a Source Qualifier with Mapping Variable
      Slowly Changing Dimensions Type 1, Type 2, Type 3
      Incremental Loading
  • SCD 1, 2, 3
      Reusable Workflow Tasks
      Worklets Limitation
      Reusable Sessions
  • Create Worklets using Tasks Command Line Interface ( PMCMD)
      Overview of PMCMD and functions
      Overview of PMREP and functions
      Informatica Migrations:
      Copying Objects
      Objects export and import (XML)
      Deployment groups
  • Workflows Scheduling
      Using Informatica
      Unix crontab, third party tools
  • Informatica Project- Case Study
      Sales Data mart
      Loading Dimensions and Facts
  • ETL Best Practices and methodologies
      Review the Industry best practices in ETL Development
      Review Real time project experiences of trainer
      Discuss what is learned techniques are useful in real world
      How to design effective ETL process
      Important considerations in designing ETL process
      Discuss real world prouction issues and support
      Discuss various roles in ETL world
      Busines Analyst, System Analyst
      System Architect
      Technical Architect, ETL Lead
      Stakeholders, Busines users
      Effective ways of using Data warehouse


Informatica is one of the most popular ETL (Extraction, Transformation and Loading) tools in the market today. Informatica Power Center provides an environment to load data into a centralized location such as an Operational data Store (ODS) or a data mart or a data warehouse. U can extract the data from various data sources such as flat files, or any Database or even COBOL files, Transform the data based in business logic and load data into different types of targets including files and relational databases.

Informatica provides the following components:

  • Informatica Repository
  • Informatica Client
  • Informatica Server

Informatica Repository: The Repository is the core of the Informatica suite. Repository database contains a set of metadata tables that the Informatica tools and applications access. The Informatica Client and server access the repository to save and retrieve metadata. Informatica Client: The PowerCenter Client is comprised of applications that you use to manage the repository, design mappings and mapplets, create sessions and workflows to load the data, and monitor workflow progress.The Informatica Client consists of three client applications.

  • Repository Manager
  • Designer
  • Server Manager

In this tutorial, you use the following applications and tools:

Repository Manager. Use the Repository Manager to create and administer the metadata repository. You use the Repository Manager to create a repository user and group. You create a folder to store the metadata you create in the lessons. Repository Server Administration Console. Use the Repository Server Administration console to administer the Repository Servers and repositories. Designer Use the Designer to create mappings that contain transformation instructions for the PowerCenter Server. Before you can create mappings, you must add source and target definitions to the repository. Designer comprises the following tools:

  • Source Analyzer. Import or create source definitions.
  • Warehouse Designer. Import or create target definitions.
  • Mapping Designer. Create mappings that the PowerCenter Server uses to extract, transform, and load data.,/li>
  • Workflow Manager. Use the Workflow Manager to create and run workflows and tasks. A workflow is a set of instructions that describes how and when to run tasks related to extracting, transforming, and loading data.
  • Workflow Monitor. Use the Workflow Monitor to monitor scheduled and running workflows for each PowerCenter Server.

Informatica Server: The Informatica Server extracts the source data, performs the data transformation and loads the transformed data into the targets. Sources accessed by Powercenter

  • Relational: Sybase, Oracle, IBM DB2, Informix, MS SQL Server and Teradata.
  • File: Fixed and delimited flat files, COBOL files and XML files
  • Extended: If u use Power Center, u can purchase additional Powerconnect products to connect to other business sources such as SAP R/3, Siebel, etc.
  • Mainframes: If u use Power Center, u can purchase additional Powerconnect products to connect to IBM DB2 on MVS
  • Others: MS Access and MS Excel

Informatica repository

The Informatica repository is at the center of the Informatica suite. You create a set of metadata tables within the repository database that the Informatica applications and tools access. The Informatica Client and Server access the repository to save and retrieve metadata.

Informatica Client

Use the Informatica Client to manage users, define sources and targets, build mappings and mapplets with the transformation logic, and create sessions to run the mapping logic. The Informatica Client has three client applications: Repository Manager, Designer, and Workflow Manager.

Informatica Server

The Informatica Server extracts the source data, performs the data transformation, and loads the transformed data into the targets.

Process Flow

Informatica Server moves the data from source to target based on the workflow and metadata stored in the repository.

A workflow is a set of instructions how and when to run the task related to ETL.

Informatica server runs workflow according to the conditional links connecting tasks.

Session is type of workflow task which describes how to move the data between source and target using a mapping.

Mapping is a set of source and target definitions linked by transformation objects that define the rules for data transformation.


A transformation is a repository object that generates, modifies, or passes data

The Designer provides a set of transformations that perform specific functions

Data passes into and out of transformations through ports that you connect in a mapping or mapplet

Transformations can be active or passive



For updated Schedules please contact