Informatica Training

Associated Courses

  • Informatica



Course Description

Informatica is a tool, supporting all the steps of Extraction, Transformation and Load process. Now a days Informatica is also being used as an Integration tool.

Informatica is an easy to use tool. It has got a simple visual interface like forms in visual basic. You just need to drag and drop different objects (known as transformations) and design process flow for Data extraction transformation and load. These process flow diagrams are known as mappings. Once a mapping is made, it can be scheduled to run as and when required. In the background Informatica server takes care of fetching data from source, transforming it, & loading it to the target systems/databases.

Informatica can communicate with all major data sources (mainframe/ RDBMS/ Flat Files/ XML/ VSM/ SAP etc), can move/transform data between them. It can move huge volumes of data in a very effective way, many a times better than even bespoke programs written for specific data movement only. It can throttle the transactions (do big updates in small chunks to avoid long locking and filling the transactional log). It can effectively join data from two distinct data sources (even a xml file can be joined with a relational table). In all, Informatica has got the ability to effectively integrate heterogeneous data sources & converting raw data into useful information.

Course Contents

1-      Data Warehousing Concepts

2-      Data ware housing (what/why/how)

3-      Data Modelling (Schemas ,FACTS and DIMESNION)

4-      Slowly Changing Dimensions

5-      Metadata

Introduction to  Informatica

  • Overview
  • Basic definition
  • Informatica products
  • Informatica Architecture
  • Tools and their roles
  • Folder-sub folders
  • Power center/power mart
  • Difference between 7x and 8x


  •  Introduction to designer
  •  Designer interfaces
  •  Designer tools
  •  Defining sources

            Data base as a source

            Flat Files sources

  • Defining Targets

              Importing from database

              Creating a new target

              Creating target database objects



  •  Mapping Introduction
  •  Source Qualifier
  •  Ports
  •  Mapping-Table to Table
  •  Mapping flat file to Table 
  • Connected/unconnected Transformation 
  • Active and Passive Transformation
  •  Source Qualifier Transformation
  •  SQL override in Source
  •  Mapping Source Qualifier as Filter
  •  Source Qualifier to join data
  •  Filter Transformation
  •  Expression Transformation
  •  Sequence Generator Transformation
  •  Rank Transformation
  •  Router Transformation
  •  Aggregator Transformation
  •  Joiner Transformation
  •  Stored Produce Transformation
  •  Connected and unconnected transformation
  •  Union Transformation
  •  XML transformation
  •  Mapping Wizards
  •  Implementing Type-| ,Type || and Type ||| mapping

  • Workflow introduction
  • Tasks
  • Workflow
  • Connections
  • Defining Task

          Command Task

          Email Task

          Session Task

  • Setting properties of session Task
  • Creating workflow
  • Starting workflow
  • Monitoring workflow


Incremental Aggregation

Mapplet Implementation

Target Load Plan

Constraint Based Loading

Mapping Variables

Session Parameters

Link Conditions

Copying Repository

Deleting Repository

Creating Folders

int(19) int(0) array(3) { ["status"]=> bool(false) ["debug"]=> string(28) "{"course_id":19,"user_id":0}" ["warnings"]=> array(0) { } }

Course Assignments

News forum

ETL - The process of updating the datawarehouse

SQL Script - Scott

Datawarehouse Concept

Informatica Transformation

Informatica Transformations- Word Format

Rank and Transaction Control Transformation in Informatica


Connected and Unconnected look up

Getting Started

An Overview of the Update Strategy Transformation in Informatica

Update stratgey Scenarios

SCD Type1


SCD Type 2 - PDf

Change Data Capture

Comments are closed.