informatica online training

Informatica Online Training with Free tutorials

Informatica is an autonomous organization that was established in 1993, which is giving information reconciliation programming and services. Informatica execution tuning is the most critical and it is said to be a vital part of ETL advancement or data warehouse. Nowadays every business needs people, need information in a quick manner, and this is where Informatica comes in handy. So now you can learn more new techniques and Learn, develop and improve your knowledge of Informatica Training with us.

informatica online training

informatica online training

Informatica is a software development company that is headquartered in California, USA. It mainly offers a plethora of products for ETL, data quality, data masking, data virtualization, data replica, master data management, etc.  Informatica is one of the most extensively used ETL instrument for getting the root data and reloading owing to bringing out the required change. It offers a plethora of products for ETL, data masking, replica, virtualization, and the Informatica PowerCenter ETL is the most widely used tool which is commonly called Informatica. It can easily connect and fetch days from multiple sources and process easily. This tool is mostly used for data integration that provides the competence to connect and to get data.


The Informatica PowerCenter 9.6.0 is the latest version in Informatica and it is available in following editions

  • Standard Edition
  • Advanced Edition
  • Premium Edition


You can now get Informatica developer training with real-time experts at OHO Training. We believe that when you get the exposure from trainers you will be learning Informatica online in a mixture of practical as well as the theoretical way which will be the easiest way to understand the technology. The trainers have designed the course from basic level to the latest advanced level. They will also guide the candidates to respective Informatica certifications which is an added advantage.  Here at Oho Training, our trainers will be helping you master this tool with interactive online sessions. The advantage of mastering Informatica here with us at Oho Training is that the sessions will be covered by faculty who are currently working in live ETL projects thus giving you an insight into how this ETL tool used in today’s business. Therefore if you are looking for a promising IT career for a long time, then look no further, ETL is your answer and Oho Training is your best solution.


Who are the trainers


The trainers are real time working professionals who are certified and have a minimum of 8+ years of experience, providing Informatica online training and there are many others who are into it full time. They will be covering all the aspects right from the introduction to live to load with lots of live practical examples.


Who can take up the course

The following people can take up the course

  • Business Analysts
  • Project Managers
  • Technical specialists
  • Freshers and STEM graduates
  • Database professionals who want to enter the field of Informatica.
  • End users


How is the market right now for Informatica


Informatica has been one of the most picking technology for the past few years and it has picked up demand in recent times and now the most accepted and famous technology in the world of BI. The demand and supply are a prominent and owing to the high demand the supply is very less in recent times as you have to catch up on the supply-demand curve and make the best out of it. The trend is also seen positive these days and openings are there in the market in huge numbers. You will have to develop more skills as there are changes coming up in the industry and you must buck up big time.


In today’s competitive IT environment, you need to differentiate yourself from the rest. This is where you need to prove that you have the knowledge and skills required to meet today’s complex data integration challenges. You need to establish your professional credibility with your employer and within the greater IT industry. The Informatica Certification that you take at the end of the course will be providing you with new opportunities to help improve your productivity, enhance your marketability, and also increase your career success with no regard of your job title. You can become an Informatica Certified Professional once you pass the test.


  • Introduction to Data warehouse
  • What is Data warehouse and why we need Data warehouse
  • Datawarehousing Architecture
  • OLTP vs ODS vs Data warehouse
  • Dimensional modeling
  • Star schema/Snowflake schema/Galaxy schema
  • Dimensions / Facts tables.
  • Slowly Changing Dimensions and its types
  • Data Staging Area
  • Different types of Dimensions and Facts.
  • Data Mart vs Data warehouse
  • Slowly Changing Dimensions-Type 1 and Type 2
  • ETL concept and ETL Architecture
  • Introduction to informatica Power Center
  • PowerCenter 9.x architecture
  • Extraction, Transformation and loading process
  • Designer, Workflow manager, Workflow Monitor, Repository Manager.
  • Repository Server and agent
  • Repository maintenance
  • Repository Server Administration Console
  • Security, Repository, privileges and folder permissions
  • Metadata extensions
  • Source types
  • Source properties
  • Target types
  • Target properties
  • Transformation types and views
  • Transformation features and ports
  • Informatica functions and data types
  • Mapping components
  • Source Qualifier transformation
  • Pre SQL and Post SQL
  • Mapping validation
  • Data flow rules
  • Workflow Tools
  • Workflow Structure and configuration
  • Workflow Tasks
  • Workflow Design and properties
  • Session Task properties
  • Session components
  • Transformation overrides
  • Session partitions
  • Workflow Monitor views
  • Monitoring a Server
  • Actions initiated from the workflow Monitor
  • Gantt chart View and Task view
  • Debugger features
  • Debugger windows
  • Tips for using the Debugger
  • Expression
  • variable ports
  • storing previous record values
  • Input/ output / Variable ports
  • Port Evaluation
  • Filter properties
  • Expressions and Filter
  • Aggregation function and expressions
  • Aggregator properties
  • Using sorted data
  • Incremental Aggregation
  • Joiner types
  • Joiner conditions and properties
  • Joiner usage and Nested joins
  • Aggregator
  • Heterogeneous join
  • Importing and editing flat file sources & Targets
  • Use Flat file as source
  • Sorter properties
  • Sorter limitations
  • Sorter
  • Propagate Attributes.
  • Shared Folder and Working with shortcuts.
  • Informatica built in functions
  • Lookup principles
  • Lookup properties
  • Lookup techniques
  • Connected and unconnected lookups.
  • Basic Lookup
  • Update strategy expressions
  • Data Driven Inserts and Rejects
  • Using a router
  • Router groups
  • Router
  • Usage and techniques
  • Advantage
  • Functionality
  • Straight Load
  • Conditional Lookups
  • Heterogeneous target types
  • Target type conversions and limitations
  • Heterogeneous Targets
  • Functionality and Advantages
  • Mapplet types and structure
  • Mapplet limitations
  • Advantages
  • Limitations
  • Promoting and copying transformations
  • Reusable transformations
  • Using a sequence Generator
  • Sequence Generator properties
  • Dynamic lookup theory
  • Usage and functionality
  • Advantages
  • Dynamic Lookup
  • Concurrent Workflows
  • Sequential Workflows
  • Stopping, Starting and suspending tasks and workflows
  • Sequential Workflow
  • Transformations
  • Overview of Error Handling Topics
  • Error handling fatal and non Fatal
  • Overview of System Environment
  • Identifying Bottlenecks.
  • Optimizing Source, Target, mapping, Transformation, session
  • Introduction to Mapping Variables and Parameters
  • Creating Mapping Variables and Updating Variables
  • Creating Parameter File and associating file to a Session
  • System Variables
  • Variables functions
  • Override Mapping Variable with Parameter Files



Matt Demon

Learning Scientist & Master Trainer
Matt Demon has been a professional educator
for the past 18 years. He’s taught, tutored,
and coached over 900+ students, and he
holds degrees in Computer Science
from Harvard University. He has
spent the last 7 years studying how
people learn to code and develop applications.

John Britto
Learning Scientist & Master Trainer
He has been a professional educator for
the past 17 years. He’s taught, tutored,
and coached over 700 students, and
he holds degrees in Information Technology
from Brooklyn University. He has
spent the last 8 years studying how
people learn to code and develop applications.


User Rating 0 (0 votes)


Enquire here to boost your career

REACH US +1 408-389-3603

Training QueriesDemo



Service Type
Provider Name
oHo Training,
2603,Camino Ramon Suite 250,San Ramon, CA-94583,
World Wide
At OHO training we have arranged for informatica online training classes. Approach to the trainers here and gain informatica knowledge. Gain certification at the end.