Basic Introduction


Informatica is one of the most widely used ETL tools for data warehousing and business intelligence. This is the tool that provides DW solution to more than 70% of all DWBI projects today. Informatica is emerging in the market and overcoming all challenges of DWBI compared to any of its competitors.

NI Analytics India Best Informatica Training Institute in Bangalore in-terms of syllabus and expert teaching. We are covering almost all the transformations which is required for companies in Informatica. Informatica is one of the leading data integration software available in the IT market today.

If you are looking forward to a promising career in Data warehousing BI informatica is the best choice

Informatica Training Syllabus

Data Warehouse Introduction

Power Center Components

  • Designer
  • Repository Manager
  • Workflow Manager
  • Workflow Monitor
  • Power Center Admin Console
  • DataStage Workflow

Informatica Concepts and Overview

  • Informatica Architecture


  • Working with relational Sources
  • Working with Flat Files


  • Working with Relational Targets
  • Working with Flat file Targets

Transformations – Active and Passive Transformations

  • Expression
  • Lookup –Different types of lookup Caches
  • Sequence Generator
  • Filter
  • Joiner
  • Sorter
  • Rank
  • Router
  • Aggregator
  • Source Qualifer
  • Update Strategy
  • Normalizer
  • Union
  • Stored Procedure
  • Slowly Changing Dimension
  • SCD Type1
  • SCD Type2 — Date, Flag and Version
  • SCD Type3

Workflow Manager

  • Creating Reusable tasks
  • List and describe partitioning and collecting algorithms
  • Workflows, Worklets & Sessions
  • Tasks
  • Session
  • Decision task
  • Control Task
  • Event wait task
  • Timer task
  • Monitoring workflows and debugging errors

Indirect Loading

Constraint based load ordering

Target Load plan

Worklet ,Mapplet ,Resuable transformation

Migration –XML migration and Folder Copy.

Scheduling Workflow

Parameter and variables

XML Source, Target and Transformations

Performance Tuning

  • Pipeline Partition
  • Dynamic Partition
  • Pushdown optimization

Contact for Admission, Demo class, or any more queries,
Venue NI Anaytics India
Address No 29, 1st Floor, Nanjappa mansion, K H road, Opp to IDBI Bank, Bengaluru -27
Class Availability Weekdays & Weekends
For Demo Class Call – +91-9535024636 / 9916806516, Email :