Informatica Course

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 Training

Informatica provides the market’s leading data integration platform.

Tested on nearly 500,000 combinations of platforms and applications, the data integration platform inter operates with the broadest possible range of disparate standards, systems, and applications. This unbiased and universal view makes Informatica unique in today’s market as a leader in the data integration platform.

It also makes Informatica the ideal strategic platform for companies looking to solve data integration issues of any size.

If 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.


• Introduction to Data Warehousing
• What is Data Warehousing?
• Who needs Data Warehouse?
• Why Data Warehouse is required?
• What is difference between Database & Data Warehouse?

Types of systems


Maintenance of Data Warehouse

• Data Warehousing Life Cycle
• Data Warehouse Architecture
• Source
• Integration Layer
• Staging Area
• Targets

Different types of Data Warehouse Approaches

• Top
• Down Approach
• Bottom
• Down Approach
• Difference between Top
• Down & Bottom
• Down Approach
• Definition of
• Data Mart
• Different types of Data marts
• Difference between Data mart & Data warehouse
• Data Modeling

What is Data Modelling?

Different types of Data Model ling
What is Dimension?
• R Modeling
• Dimensional Modeling

Different types of Dimensional Modeling

• Star Schema
• Snow flake schema
• Galaxy schema

Types of systems
What is Fact?
What is Granularity?
Types of fact?
• Additive fact
• Semi additive fact
• Non additive fact
• Fact less Fact Table

Types of Dimensions?

• Confirmed Dimension
• Junk Dimension
• Dirty Dimension
• Degenerative Dimension
• Informatics
• Introduction to Informatics
• Architecture of Informatics
• Informatics Client tools
• Informatics power centre Repository
• Informatics power centre Designer
• Informatics power centre WORKFLOW DESIGNER
• Informatics power

ODBC Connections of Informatics

• Power centre Designer Tools
• Source Analyzer
• Target Designer
• Transformation Developer
• Mapping Designer
• Mapplet Designer

Types of Transformations

• Source Qualifier Transformation
• Filter Transformation
• Joiner Transformation
• Expression Transformation
• Sorter Transformation
• Aggregator Transformation
• Rank Transformation
• Union Transformation
• Router Transformation
• Sequence
• Generator
• Lookup Transformation
• Update strategy Transformation
• Normalizes Transformation
• Stored Procedure Transformation
• Transaction Control Transformation

Implementation of Slowly Changing Dimensions (SCD)

• Implementing SCD Type
• Implementing SCD Type
• Informatics Workflow Manager
• Task
• Workflow
• Work let
• Workflow Task
• Scheduling
• Workflows
• Batch Processing
• Informatics Advanced Topics
• Implementing Mapplet
• User

Defined Functions

• Debugging
• Mapping Parameters
• Mapping Variables
• Cache
• Target Load Plan
• Implementing Work let
• Session Properties
• Test Cases
• Running the workflow By using PMCMD & PMREP
• Conversion of STRINGS to Date Data type

Want to have a course urgently or on Fast track. We can arrange you for a specialised training aimed only for you. Please get in touch with us with your requirements by mail or just fill in the Batch Enquiry form. We will get in touch with you with the slot times and other details with in 24 hours

For Priority Training contact below
  • eITCafe: trainings@eitcafe.com
  • India: 040 6678 6677
  • US: 630-636-0198

Support services

We know how hard it can be to find and keep a job when there are so many other things to worry about. Our support team is here to help break down the barriers which are blocking your road to employment.
If you are a Working Chance candidate, please don’t hesitate to ask for advice or support on any issues which are affecting your chances of finding a job.
For further information, please email jobsupport@eitcafe.com our Support and Training Manager.

Job Preparation

• Assistance with learning job seeking skills
• Resume creation
• Master application completion
• Dressing for success
• Job interview preparation

Job Development

• Assistance with completing applications online or in person
• Job development online, on foot, networking events, job fairs and established employer relationships to locate available positions in your job goal
• Job leads and information on attending hiring events
• Follow-ups on applications placed to request interviews.

What do you mean by Enterprise Data Warehousing?

When the organization data is created at a single point of access it is called as enterprise data warehousing. Data can be provided with a global view to the server via a single source store. One can do periodic analysis on that same source. It gives better results but however the time required is high.

What is meant by a domain?

When all related relationships and nodes are covered by a sole organizational point, its called domain. Through this data management can be improved.

What is the difference between a repository server and a powerhouse?

Repository server controls the complete repository which includes tables, charts, and various procedures etc. Its main function is to assure the repository integrity and consistency. While a powerhouse server governs the implementation of various processes among the factors of server’s database repository.

How many repositories can be created in informatica?

There can be any number of repositories in informatica but eventually it depends on number of ports.

What is the benefit of partitioning a session?

Partitioning a session means solo implementation sequences within the session. It’s main purpose is to improve server’s operation and efficiency. Other transformations including extractions and other outputs of single partitions are carried out in parallel.

Key Features


Overview of Course and Learning analytic’s


Learn from Certified and Expert Trainers

Customized Course as per your requirement

24/7 online support for the course learners

High Quality E-learning Content for learning


Access to the Recorded Sessions and classes

Flexible Course timing and Payment terms

Live Practical Oriented Approach for learners

Course Curriculam

Informatica Course Modules

Duration: 45 Days

Support: 24×7

Video: Yes

Informatica Certified Professional