Informatica Online Training

We people when comes into IT industry might be hearing of the BI tools many times. But have you thought what does this BI tool mean?  And how does it helps the developers?  These BI tools are in use over the past few decades. But the need of it came to know now – a –days. And we have many BI tools in the IT market. One among those many BI tools is Informatica. This Informatica is a powerful BI in the IT market. One of the source is  Informatica Online Training.

Today we have many developers in the IT market. This developer can be front-end programming developers  (or) back-end database developers. But in this technology evolving world these two were not enough. We need something new additionally. It means Querying the data is not enough, we need to analyze the data that was queried. This can be done with the help of tools.

Informatica Online Training :

Informatica is one among the various BI tools in the IT industry. This tool collects the data from heterogeneous data sources and integrates it. Through the interactive dashboards, the analyst can analyze the data. Many people think that online training has a less demand in the It industry. They think people do not teach well in the Online Training. But the days were changed. Today most of the people prefer to the online training when compared to the offline training. This is because online training saves time.

OnlineITGuru explains the following concepts of  Informatica:

Here we are going to learn more Topics about Informatica from the beginning By OnlineITGuru experts team with the support of Live project support.

OnlineITGuru provides rich quality knowledge to the students.  And the trainers were real-time experience faculty.  OnlineITGuru trainers have a minimum of 10 years of Industry experience. Additionally, through this course, OnlineITGuru organize show you the placements in MNC (Multi-National Companies ).

Course Information

Informatica is a software development company that focuses on creating products that help in data integration, information lifecycle management, ETL, B2B data exchange, cloud data integration, data masking, event processing, data virtualization, ultra-messaging and master data management.

In simpler terms Informatica’s toolset help users establish and maintain large data warehouses.

Informatica’s tools have the ability to share resources and services with several machines. The most famous product of Informatica is Informatica PowerCenter. It consists of 3 major components. These components being,

• Informatica PowerCentre Client Tools are installed at the developer’s end of the software. These tools help the developer to map, monitor execution of various sessions, manage a repository and report Meta data.
• Informatica PowerCenter Repository works in the backend of the Informatica Tools. This is where all the Metadata for the applications related to the PowerCenter are stored.
• Informatica PowerCenter Server: All the executions take place in the server. It is the server’s job to make physical connections between the sources and targets, fetch data and apply transformations specified in the earlier mentioned map(s).

Features of Informatica:
• Data Integration: the accuracy of data in the transformation and profiling is necessary.
• Security: With the help of security options and user authentication, the data involved remains private and secure.
• Visual Interface: A simple user interface is always appreciated.
• Compatibility of the tool helps users maintain records and move large chunks of data efficiently.

Who Should Take This Course?

Scope of Informatica is already vast in many industries. Informatica is constantly attempting to improve this item and as I would like to think. Candidates who will work in the business stage can go to this. Informatica is generally used in extraction transformation stacking (ETL) tool as a part of building enterprise data warehouses. The accompanying experts can go for this course:

  • Programming Developers
  • BI/ETL/DW Professionals
  • Willing to work in Enterprise Business Intelligence
  • Architects

What Are The Prerequisites?

Basic Knowledge on UNIX, ETL is required. SQL is benefited but not mandatory. Other than no particular essential are not required. The Trainer will help you on the nuts and bolts and basic those are required.

Hands-On Experience

Our guide will support on Real-time Projects with 24*7 team. A lead can play out a traditional of care on the course. This is reasonable to understudies and appearance trainer at the working assignments and Real-time Projects.

Course Features

Online Course Duration Course Duration : 30 Hrs

Highly interactive, reliable and quality learning sessions of the course are conducted by Online IT Guru. For a better learning experience, the courses are divided into distinctive phases and sessions.

Realtime Project Work Hands on Experience

Every module shall be followed by a practical experience of lab exercises. At the end of the course, the students will have to build a project on the concepts that were taught to them during the course duration.

Access Duration Life time Access Duration: Lifetime

Students will have a life time access to the course materials provided by Online IT Guru. Students also have an opportunity to decide the duration of the course as per their schedule and convenience.

24x7 Support 24 X 7 Support

Concerned faculty can be contacted by the students if they are looking for help and assistance with respect to the course and its material. Students can approach their respective faculty to clear their quires either by email, phone or through live chat.

Online Course Certification Get Certified

At the end of the course, students will have to fare well in quizzes and testes conducted by the institute and the faculty in order to receive the required certification. To clear the Certification test with flying colours, students will be given model questions and certification dumps that would make them confident about attempting the test to get their Certification.

Placement Assistance Job Assistance

Online IT Guru will help students find job opportunities with the newly acquired skill set. Online IT Guru has a varied bunch of Clientele around the globe, over 30+ companies in USA and India that have experience in working with different technologies. We would pass your resumes to them after the completion of the course and ensure that the students achieve 100% placements. During the testing and interview process for them, the required assistance shall be provided by Online IT Guru.

Core topics of Informatica Online Course

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


  1. OLAP
  • Maintenance of Data Warehouse
  • Data Warehousing Life Cycle

Data Warehouse Architecture

  • Source
  • Integration Layer
  • Staging Area
  • Targets
  • ODS

Different types of Data Warehouse Approaches

  1. Top-Down Approach
  2. Bottom-Down Approach
  3. Difference between Top-Down & Bottom-Down Approach
  4. Definition of  Data Mart
  5. Different types of Data marts
  6. Difference between Data mart & Data warehouse

Data Modelling

  • What is Data Modelling?
  • Different types of Data Model ling
  • What is Dimension?
  1. E-R Modelling
  2. Dimensional Modelling
  • Different types of Dimensional Modelling
  1. Star Schema
  2. Snow flake schema
  3. Galaxy schema
  • What is Fact?
  • What is Granularity?
  • Types of fact?
  1. Additive fact
  2. Semi additive fact
  3. Non additive fact
  4. Fact less Fact Table
  • Types of Dimensions?
  1. Confirmed Dimension
  2. Junk Dimension
  3. Dirty Dimension
  4. Degenerative Dimension

Introduction To  Informatica

  • Introduction to Informatica
  • Architecture of Informatica
  • Informatica Client tools
  1. Informatica power centre Repository
  2. Informatica power centre Designer
  3. Informatica power centre WORKFLOW DESIGNER
  4. Informatica power centre WORKFLOW MONITOR
  • ODBC Connections of Informatica

Power centre Designer Tools

  1. Source Analyser
  2. Target Designer
  3. Transformation Developer
  4. Mapping Designer
  5. Mapplet Designer

Types of Transformations

  1. Source Qualifier Transformation
  2. Filter Transformation
  3. Joiner Transformation
  4. Expression Transformation
  5. Sorter Transformation
  6. Aggregator Transformation
  7. Rank Transformation
  8. Union Transformation
  9. Router Transformation
  10. Sequence Generator
  11. Lookup Transformation
  12. Update strategy Transformation
  13. Normaliser Transformation
  1. Stored Procedure Transformation
  2. Transaction Control Transformation

Implementation of Slowly Changing Dimensions (SCD)

  1. Implementing SCD TYPE-1
  2. Implementing SCD Type-2
  3. Implementing SCD Type-3

Informatica Workflow Manager

  1. Task
  2. Workflow
  3. Worklet
  4. Workflow Task
  • Scheduling  Workflows
  • Batch Processing

Informatica Advanced Topics

  • Implementing Mapplet
  • User-Defined Functions
  • Debugging
  • Mapping Parameters
  • Mapping Variables
  • Cache
  • Target Load Plan
  • Implementing Worklet
  • Session Properties
  •  Test Cases
  • Running the workflow By using PMCMD  & PMREP
  • Conversion of  STRINGS  to Date Data type
  • Link-Conditions



  1. The course material and coaches are simply and amazing.

    The Onlineitguru Informatica web based preparing is an extraordinary approach to finding out great way in business intelligence. The course material and coaches are simply and amazing. I highly recommend it to everybody. Trust me you are gonna love it!

    Online Training Reviews

    Vijaya A

  2. I did Informatica certification course from here.

    Now I am a specialist in this Informatica business apparatus. I took this instructional class and I am certainly elated! I did Informatica certification course from here. Best organization everlastingly and after achievement my Informatica course they helped me out for college from an institute.

    Online Training Reviews

    Bhavya Shyam

  3. Trainer was extremely COMMITTED, Knowledgeable and all the more imperatively PATIENT.

    This quality was great. A trainer was extremely COMMITTED, Knowledgeable and all the more imperatively PATIENT. I preferred the way points were flowed and perform that is wonderful! Much thanks for such a positive interest. I very prescribe to Supporting team and Onlineitguru.

    Online Training Reviews

    Abhi Nav

  4. The practices given are extremely useful

    When I began I had no information of translate and now I feel exceptionally certain about the area. The practices given are extremely useful and great care is appeared and support that you the subject and idea are well understood. I exceedingly prescribe for anybody wanting to seek after in Informatica Course.

    Online Training Reviews

    Sivanand ADARI

Contact Us
+1 732 703 9066
+91 888 544 8788
Offer : Get Any BI Self-Paced Videos Free With This Course!
  • Lifetime access with high-quality content and class recordings
  • 40 hours of course presentations by hands-on experts
  • 30 hours of lab time
  • 24x7 online support
Live Online Training

Mon -Fri (5 Weeks)
For Business
    Corporate Training
  • Practical knowledge with key modules (Self-paced and Instructor command options)
  • Training schedule has been preparation with regularly updated contents
  • Project quality with Learning Management System (LMS)
  • 24x7 assistance and support
Project Support
  • Daily 2 hours session
  • 6 Days support per week

100% Secure Payments. All major credit & debit cards accepted.