Since internet availability is increasing more and more, data generation is happening exponentially. And this data contains some useless information. So we need to extract this data to get useful information. Informatica is the popular ETL tool to extract the information from the data. Kits Online Training provides the best knowledge on Informatica by live experts online.  Informatica Online Training suits best for both freshers as well as experienced professionals from other domains.

 This Informatica course covers the essential basics of the ETL process and the moves with the ETL process in Informatica. This Informatica course was intended to impart hands-on experience on PowerCenter, working on data warehouse, administration, and deploying the transformation through real-world projects. Kits real time experts have designed the Informatica course to impart hands-on experience on Informatica and shows the way to clear certification. Besides Informatica trainings, Kits provides the best knowledge on various platforms like Tableau, power bi, msbi, python, salesforce, selenium with live use cases.

Informatica 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

Highlights of Informatica Online training:-

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

*  We Also provide Case studies  for Informatica Online 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 Online Training.

* We also provide Cost Effective and Flexible Payment Schemes.


What is Informatica?

Informatica is a Software development company, which offers data integration products. It offers products for ETL, data masking, data Quality, data replica, data virtualization, master data management, etc.

Informatica Powercenter ETL/Data Integration tool is a most widely used tool and in the common term when we say Informatica, it refers to the Informatica PowerCenter tool for ETL.

Informatica Powercenter is used for Data integration. It offers the capability to connect & fetch data from different heterogeneous source and processing of data.

For example, you can connect to an SQL Server Database and Oracle Database both and can integrate the data into a third system.

Informatica ETL tool consists of following services & components

  1. Repository Service – Responsible for maintaining Informatica metadata & providing access of same to other services.
  2. Integration Service – Responsible for the movement of data from sources to targets
  3. Reporting Service – Enables the generation of reports
  4. Nodes – Computing platform where the above services are executed
  1. Informatica Designer – Used for creation of mappings between source and target
  2. Workflow Manager – Used to create workflows and other task & their execution
  3. Workflow Monitor – Used to monitor the execution of workflows
  4. Repository Manager – Used to manage objects in repository

In this tutorial- you will learn

  • Informatica Domain
  • PowerCenter Repository
  • Domain Configuration
  • Properties of the domain
  • Powercenter client & Server Connectivity
  • Repository Service
  • Integration Service
  • Sources & Targets

PowerCenter Repository

PowerCenter repository is a relational database like Oracle, Sybase, SQL server and it is managed by repository service. It consists of database tables that store metadata.

There are three Informatica Client tools available in Informatica Powercenter. They are Informatica

  • Designer
  • Workflow Monitor
  • Workflow Manager

These clients can access to the repository using repository service only.

To manage a repository there exists an Informatica service called Repository Service. A single repository service handles exclusively only one repository. Also, a repository service can execute on multiple nodes to increase the performance.

The repository services use locks on the objects, so multiple users cannot modify the same object same time.

You can enable version control in the repository. With the version control feature, you can maintain different versions of the same object.

Objects created in the repository can have following three state

  • Valid: Valid objects are those objects whose syntax is correct according to Informatica. These objects can be used in the execution of workflows.
  • Invalid: Invalid objects are those who does not adhere to the standard or rules specified. When any object is saved in Informatica, it is checked whether its syntax and properties are valid or not, and the object is marked with the status accordingly.
  • Impacted: Impacted objects are those whose child objects are invalid. For example in a mapping if you are using a reusable transformation, and this transformation object becomes invalid then the mapping will be marked as impacted.

Powercenter client & Server Connectivity

PowerCenter client tools are development tools which are installed on the client machines. Powercenter designer, workflow manager, a repository manager, and workflow monitor are the main client tools.

The mappings and objects that we create in these client tools are saved in the Informatica repository which resides on the Informatica server. So the client tools must have network connectivity to the server.

On the other hand, PowerCenter client connects to the sources and targets to import the metadata and source/target structure definitions. So it also must have connectivity to the source/target systems.

  • To connect to the integration service and repository service, PowerCenter client uses TCP/IP protocols and
  • To connect to the sources/targets PowerCenter client uses ODBC drivers.

What you will learn in this Informatica Training Course?

  • Learn about the Informatica architecture and Informatica Powercenter
  • Installation and configuration of Informatica
  • Learn to manage and monitor Informatica workflow
  • ETL functionalities and scenarios
  • Informatica SQL and XML transformation
  • Prepare yourself for Informatica certification

Who should take this Informatica Certification Course?

  • Business Intelligence, ETL, SQL, database professionals, project managers and graduates
  • looking to make a career in BI.

What are the prerequisites for this Informatica training?

You don’t need any specific skills to learn Informatica. Basic knowledge of SQL can be helpful to take this Informatica training.

Scheduling Demo With Trainer:

If you would like to take the online demo for Informatica trainer can you please make an inquiry or fill the form for demo registration, one of our executives will arrange a meeting with the expert trainer.

Course Finished Certificate :

After finish, the course we provide Informatica course finished certificate of kits technologies looks like

datastage online training




Contact For More Information On Informatica Training                 informatica enquiry

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

informatica enquiry

Request for demo

Informatica Demo Srinivas

Informatca Demo – Trainer Madhan

informatica enquiry

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