Informatica Certification Training

Viswa Online Trainings is one of the world’s leading online IT training providers. We deliver a comprehensive catalog of courses and online training for freshers and working professionals to help them achieve their career goals and experience our best services.

4627 Reviews 4.9

Learners : 1080

Duration :  25 Days

About Course

Informatica is an IT firm established by Mr. Dillon in California in the year 1995-96. People often refer to Informatica as software, but there are some technical tools developed by Informatica that they intend to mean. Informatica offers various data products like ETL, data migration, data integration, data virtualization, data masking, data replication, and many more. Enroll now and get certified in it.

Informatica Training Course Syllabus


✔ 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 Power Center Designer

✔ Source Analyzer
✔ Target Designer
✔ Mapping Designer

Power Center Workflow Designer

✔ Workflow Designer
✔ Task developer
✔ Work let Designer

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 the 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

✔ 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 Default 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

Live Instructor Based Training With Software
Lifetime access and 24×7 support
Certification Oriented content
Hands-On complete Real-time training
Get a certificate on course completion
Flexible Schedules
Live Recorded Videos Access
Study Material Provided

Informatica Training - Upcoming Batches

7th NOV 2022



Coming Soon



5th NOV 2022



Coming Soon



Don't find suitable time ?


Live Virtual Training

  • Schedule your sessions at your comfortable timings.
  • Instructor-led training, Real-time projects
  • Certification Guidance.

Self-Paced Learning

  • Complete set of live-online training sessions recorded videos.
  • Learn technology at your own pace.
  • Get access for lifetime.

Corporate Training

  • Learn As A Full Day Schedule With Discussions, Exercises,
  • Practical Use Cases
  • Design Your Own Syllabus Based
For Business

Informatica Training FAQ'S

What is Informatica PowerCenter?

ETL tools such as Informatica PowerCenter enable data integration (combining data from different sources into a single dataset). In order to build enterprise data warehouses, it provides the ability to extract, transform, and load data from heterogeneous OLTP (Online Transaction Processing) sources systems. US Air Force, Allianz, Fannie Mae, ING, and Samsung are among the top clients using Informatica PowerCenter. There is no doubt that it has a wide range of applications. Informatica PowerCenter 9.6.0 is the latest version available.

Get ahead in your career by learning Informatica through VISWA Online Trainings

Name different types of transformation that are important?

Transformations in Informatica are the repository objects that transform the source data according to the needs of the target system and ensure that the quality of loaded data is maintained. The following transformations are provided by Informatica to accomplish specific functionalities: 

  • Aggregator Transformation: An active transformation used to compute averages and sums (especially across multiple rows or groups).
  • Expression transformation: A passive transformation suitable for calculating values in one row. In addition, conditional statements can be tested before they are written to target tables or other transformations.
  • Filter transformation: An active transformation used for filtering rows in mappings that don't meet the given condition.
  • Joiner transformation: An active transformation joins data from different sources or from the same location.
  • Lookup transformation: In order to get relevant data, a lookup transformation looks up a source, source qualifier, or target. Results of the lookup are returned to another transformation or the target object. Active Lookup transformation returns more than one row, whereas passive transformation returns only a single row.

An unconnected lookup can have how many input parameters?

An unconnected lookup can include numerous parameters. No matter how many parameters are entered, the return value will always be one. You can, for instance, put parameters in an unconnected lookup as column 1, column 2, column 3, and column 4, but there is only one return value

What is the role of a repository manager?

A repository manager is an administrative tool used to administer and manage repository folders, objects, groups, etc. A repository manager provides a way to navigate through multiple folders and repositories, as well as manage groups and user permissions.

What is Domain in Informatica?

PowerCenter services are administered and managed by the Informatica Domain. It consists of nodes and services. Each relationship and node are categorized according to the administration requirements into special folders and sub-folders.


vishal meda
vishal meda
They give trainings properly and trainers are well versed with them where i recommend to all viswa trainings are good!!
Ntr fan
Ntr fan
I just finished sap bods training in Hyderabad. Excellent course and curriculum 100% doubt clarification sessions. Thanks Chaitanya
Shiva Krishna
Shiva Krishna
I recently completed informatica online training with Chaitanya. Course was built by excellent trainer. And process of learning was streamlined. Thanks
Mohammad ali syed
Mohammad ali syed
It was great and smooth understandable training. You can learn lots.
Govinda Bhatia
Govinda Bhatia
Not recommended as there will be no server access working to do practical after training. Also there will be no fix for the same. So it's wastage of money. If server access not at all working then no meaning to provide server access. Also it not working for single day properly. Need to followup daily but in response you told will fix that sir at home once he will back will fix. After he came back again it's not working and not able to fix for single day also Every time new excuse it's wastage of money.
M Leela mohan
M Leela mohan
I took SQL Server and MSBI Online training with Murali Krishna. I must say the course content was highly qualitative and the trainer covered all concepts. Overall it was a good experience with VISWA Online Trainings.
Attended live Virtual training for IoT Trainer was very good. He had excellent knowledge of IoT and was very good at explaining concepts in detail.…
Lakshmi Lakshmi
Lakshmi Lakshmi
Best sap commerce cloud and Spartacus training institute in india. He provides a great mix of listening, speaking, and practical learning activities and a very safe, supportive learning environment. He maintains a friendly relationship with the students during class. He not only teaches but also monitors our practice status on daily basis.
Ch Chandranath
Ch Chandranath
I have undergone Oracle Tuning training. I can proudly say that this is one of the best training institutes available in the market. The way Mr. Kumar teaches the concepts and makes them understandable is very commendable and unique. Even a novice can clearly understand the concepts clearly after attending his classes.

Quick Links