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

Unit 1: Informatica Introduction

  1. Overview
  2. Basic Definitions
  3. Informatica products
  4. Informatica Architecture
  5. Folders-Sub folders
  6. ETL Tools and their roles
  7. ETL information power center / Power mart

Unit 2: Introduction To Data Warehousing

  1. Data warehousing (what is Data warehousing /Why Data warehousing/How Data warehousing)
  2. Slowly Changing Dimensions (SCD1, SCD2, SCD3)
  3. Metadata
  4. Dimensional Table
  5. Types Of Dim Tables
  6. Fact Table
  7. Types of Fact Tables
  8. OLTP (Online Transaction Processing)
  9. OLAP (Online Analysis And Processing)
  10. OLTP Vs OLAP
  11. Advantages of OLAP
  12. Different Methodologies of DWH

Unit 3: Configuration

  1. Informatica configuration
  2. Instigation Services
  3. ETL Folder
  4. ETL Job Filz

Unit 4: Introduction to Informatica Designer

  1. Introduction to Designer
  2. Logon to Designer
  3. Designer interfaces
  4. Designer Tools
  5. Defining Sources
  6. Database as a source
  7. Flat File sources
  8. Defining Targets
  9. Importing from database
  10. Creating a new target
  11. Creating target database objects

Unit 5: Transformation

  1. Aggregate Transformation
  2. Shorter Transformation
  3. Active and Passive Transformations
  4. How Sequencer work and Uses of Sequencer Transformation
  5. Filter Transformation
  6. Lookup transformation
  7. Connected lookup
  8. Unconnected lookup
  9. Joiner Transformation
  10. Filter Transformation
  11. Ranking Transformation
  12. Router Transformation
  13. Expression Transformation
  14. Sequence Generator Transformation
  15. Rank Transformation
  16. Stored Procedure Transformation(Connected and Unconnected)
  17. Union Transformation
  18. XML Transformation

Unit 6: Mapping

  1. Mapping Introduction
  2. Ports
  3. Mapping – Table to Table
  4. Mapping Flat File to Table
  5. Mapping Wizards
  6. Implementing Type-I, Type-II, Type-III Mappings

Unit 7: Qualifier

  1. Source Qualifier Transformation
  2. SQL override in source qualifier transformation
  3. Source qualifier transformation joins concept
  4. Source qualifier transformation on Relational Databases
  5. Source qualifier transformation on File systems
  6. Source qualifier transformation filter concepts
  7. Difference Between SQL Override, Other Options
  8. Source Qualifier to join Data
  9. Source Qualifier Transformation Performance Tunning
  10. Pre SQL and Post in Source Qualifier Transformation

Unit 8: Workflow Manager

  1. Workflow Introduction
  2. Tasks
  3. Workflow tools
  4. Connections
  5. Defining tasks
  6. Command Tasks
  7. Email Task
  8. Session Task
  9. Link Conditions
  10. Event Wait & Event Raise
  11. Setting Properties of Session Task
  12. Creating Workflow
  13. Starting Workflow

Unit 9: Informatica Advanced Features

  1. Incremental Aggregation
  2. Mapplet Implementation
  3. Target Load Plan
  4. Constraint Based Loading
  5. Mapping Variable
  6. Session Parameters
  7. Link Conditions
  8. Reusable Transformation
  9. Task and Types of Tasks
  10. Work let and Types of work lets
  11. Scheduling Workflow
  12. Control flow using Command task and event wait task
  13. Incremental Loading

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 435 reviews
5 1

informatica powercenter training enquiry

Request for demo

Write A Review 

Review Title
Review Content

Abinitio Training

5 5 1
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


5 5 1
Sccm training done in a good way

Oracle DBA Online Training

4 5 1
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

Best Training Instittue

5 5 1
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

My Favourite Training Instittue

5 5 1
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

sql server dba

5 5 1
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..

Other Related Courses