KITS Online Training Institute provides best Informatica PowerCenter training by our highly professional certified trainers. Informatica is a service oriented architecture and also has the capability to share service and resource across several machines. Informatica delivers enterprise data integration and management software powering analytics for big data and cloud. Dataware housing concepts will be taught prior to Informatica. Informatica PowerCenter 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.We have been offering courses to consultants, companies so that they can meet all the challenges in their respective technologies.


We are also providing similar courses like Cognos Online Training etc….

Informatica PowerCenter Training Course Content


  • Data Warehousing Concepts
  • Dataware housing (what/Why/How)
  • Data Modelling(Schemas, FACTS and DIMENSIONS)
  • Slowly Changing Dimensions
  • Metadata

PowerCenter Components and User Interface

  • PowerCenter Architecture
  • PowerCenter Client Tools
  • Lab – Using the Designer and Workflow Manager

Introduction to Informatica Power Center Designer

  • Source Analyzer
  • Target Designer
  • Mapping Designer

Informatica Power Center Workflow Designer

  • Workflow Designer
  • Task developer
  • Work let Designer

Informatica Power Center Workflow Monitor

  • Job status
  • Job session logs

Loading Strategy

  • Flat file to flat file load
  • Flat file to database load
  • Database to database load
  • Database to flat file load
  • Xml file to database load
  • Xml file to flat file load
  • Different Transformations
    • Source Qualifier
    • Source Qualifier Join
    • Source Qualifier Filter
    • Expression
    • Connected Stored Procedure
    • Unconnected Stored Procedure
    • Sequence Generator
    • Aggregator
    • Filter
    • Lookup
    • Joiner
    • Router
    • Rank
    • Sorter
    • Union Transformation
    • Xml Source Qualifier
    • Using Flat Files as Sources
    • Using Flat Files as Source and Target
    • Using XML Files as Source
    • Reading Data From Multiple Data Bases
    • Update Strategy
    • Target Load Plan

    Informatica Administration

    • Installation of Informatica
    • Installation of Oracle Database
    • Installation of SQL Server
    • Creation Repository
    • Creation of Users
    • Assigning Privileges to users
    • Creation of Groups
    • Adding the Repository to Informatica Repository Manager
    • Creating Data source Connections
    • Configuration of Sql server and Oracle Database with Informatica
    • Scheduling the Workflow

    Source Qualifier

    • Source Qualifier Transformation
    • Source Pipelines
    • Source Qualifier  Filter and Real time issues
    • Source Qualifier SQL over query

    Expression, Filter, File Lists and Workflow Scheduler

    • Expression Editor
    • Filter Transformation
    • File Lists
    • Workflow Scheduler
    • Lab – Load the Customer Staging Table and Real time issues

    Joins, Features and Techniques

    • Joiner Transformation
    • Shortcuts
    • Lab – Features and Techniques I and Real time issues

    Lookups and Reusable Transformations

    • Lookup Transformation
    • Reusable Transformations
    • Lab A – Load Employee Staging Table
    • Lab B – Load Date Staging Table and Real time issues


    • Debugging Mappings
    • Lab – Using the Debugger

    Sequence Generator

    • Sequence Generator Transformation
    • Lab – Load Date Dimension Table and Real time issues

    Router, update Strategy and Overrides

    • Router Transformation
    • Update Strategy Transformation
    • Expression Def ault Values
    • Source Qualifier Override
    • Target Override
    • Session Task Mapping Overrides
    • Lab – Load Employee Dimension Table and Real time issues

    Unconnected Lookup, Parameters and Variables

    • Unconnected Lookup Transformation
    • System Variables
    • Mapping Parameters and Variables
    • Lab – Load Sales Fact Table

    Sorter, Aggregator and Self-Join

    • Sorter Transformation
    • Aggregator Transformation
    • Active and Passive Transformations
    • Data Concatenation
    • Self -Join
    • Lab – Reload the Employee Staging Table and Real time issues

    SCD type1

    SCD type2

    SCD type3



    • Mapplets
    • Review and more Activities and Real time issues

    Worklets and More Tasks

    • Worklets
    • linkTask
    • Lab – Load Inventory Fact Table

    ANR’s, key service

    • FAQS
    • Covering DBA concepts
    • Concentration on performance tuning
    • Real time scenarios
    • Certification guidance
    • Resume preparation
    • Sample resumes
    • Interview & certification FAQS
    • How to face the interview
    • Class notes which is useful for who is trying for job

Highlights of Informatica PowerCenter Training:-

*  Very in depth course material with Real Time Scenarios for each topic with its Solutions for Informatica PowerCenter Trainings.

*  We Also provide Case studies  for Informatica PowerCenter Training.

*  We do Schedule the sessions based upon your comfort by our Highly Qualified Trainers and Real time Experts.

*  We provide you with your recorded session for further Reference.

* We also provide Normal Track, Fast Track and Weekend Batches also for Informatica PowerCenter Training.

* We also provide Cost Effective and Flexible Payment Schemes.


Contact For More Information On Informatica PowerCenter Training                 informatica powercenter training enquiry

Informatica PowerCenter Training Overall rating: ★★★★☆ 4.4 based on 438 reviews.
5 1

informatica powercenter training enquiry

Request for demo

Write A Review 

Review Title
Review Content

Abinitio Training

I Have joined for Course with Kits Technologies course.I am completely confident enough in my subject. I never thought Abinitio is SO BIG and huge!!!Loved learning it for about few week and quite happy now. Thanks Kits Team
- Ramesh


Sccm training done in a good way
- Phani

Oracle DBA Online Training

I have completed AWS Online Training From KITS Online Trainings. my trainer such a knowledgeable person. He taught a concepts easy and understandable manner. I am getting day by day update and easy understanding. Thank for the wonderful opportunity
- John

Best Training Instittue

Very nice material and course video available for your reference anytime. I repeatedly watched videos to learn required knowledge. Anyone would definitely miss out the physical presence inside the class while attending the course . I had lot of disturbance at home while class was going on and it didn't give me any seriousness about subject as I didn't see anyone looking at me if I am listening! This factor, someone is looking at me would definitely make me concentrate subject. Also 4 (four) hours of coaching online and very less interaction with people around makes very less impressive learning
- Rajesh

My Favourite Training Instittue

My learning with KITS Online Trainings was Golden Gate and SAP Basis training and exam preparation It’s been a worthwhile learning experience - the course was easier to understand than and helped memory retention. Also the online support team were so kind and helpful-when i ran out of time and my exam was a month away they extended my access for extra 30 days. Success all the way
- mandeep

sql server dba

I am Srinivas bolla. I took SQL Database Administrator Online training in Kits online trainings. actually I don’t have knowledge about IT sector, When I was approach Kits online trainings. They gave me well support and training. I learnt a lot from them very well experienced faculty.. very much satisfied for the training. I am happy to say my topics are very clear now. I have no doubt about SQL DBA am very thankful to the whole team of Kits online trainings for providing a Excellent training..
- Srinivas

Other Related Courses