Overview of Informatica

  • (4.0)
  • | 3868 Ratings

What is Informatica?

Informatica is basically an enterprise that renders data integration products. The products include ETL, Data Quality, Data Virtualization, Data Management, etc. Although it moves data from one place to another, it doesn’t store anything.

Informatica is the widely used tool which commonly refers to Informatica PowerCentre ETL tool. It connects, fetches and processes data from various heterogeneous sources. The newest version of Informatica PowerCenter in practice is 9.6.0. Informatica offers a wide-range of editions such as:

1. Standard
2. Advanced
3. Premium

User can opt a specific edition depending upon the necessity. U.S Air Force, Samsung, ING are some of the popular clients that are employing Informatica.

Enthusiastic about exploring the skill set of Informatica? Then, have a look at the Informatica Training Online together additional knowledge. 

Informatica is available for all the popular platforms. It offers cloud-based services where a tool can be setup with minimal efficiency. Informatica offers:

  1. Web services integration
  2. Real-time integration
  3. B2B Integration
  4. Master Data Management

Typical Use-Cases:

  • An enterprise which wants to migrate from existing mainframe legacy system into a latest database system.
  • Enables powerful B2B exchange with end-to-end visibility.
  • Enterprises setting up data warehouse must install an ETL tool to transfer data.
  • Data from several heterogeneous systems can be integrated using Informatica.
  • Informatica can be employed as a data cleanser.

Related Article: Informatica Concepts

Why do we need Informatica?

Informatica comes to rescue whenever the data system in the backend wants to execute certain operations. The operations can be: data cleansing, data modification, data loading, etc.

Informatica offers varied set of features, like, operating data, integrating data and scheduling data operations. It also includes the metadata feature, where data operations are well-preserved.

                      Check Out Informatica Tutorials

Components of Informatica:

Informatica Services

Below services form the Informatica PowerCenter Processing engine:

Integration Service – Conducts and Implements ETL Logic.
Repository – This database contains ETL metadata.
Repository Service – Handles connectivity to the meta data repositories. Mapping and        workflow definitions are saved.
Repository Service Process – This multi-threaded process retrieves, inserts and updates repository metadata.

Related Article:  Informatica PowerCenter

Client Applications

Informatica client applications are the tools that are used to produce transformations, handle metadata and monitor ETL processes.

Designer – A tool that develops ETL mappings.
Workflow Manager – Creates and executes workflows.
Repository Manager – Manages target connections, folders, objects, etc.
Workflow Monitor - Monitors workflows.
Administrator Console – Performs domain and repository tasks

Frequently asked Informatica Interview Questions & Answers

List of Informatica Courses:

Mindmajix offers training for many of other informatica courses depends on your requirement:

Subscribe For Free Demo

Free Demo for Corporate & Online Trainings.

Ravindra Savaram
About The Author

Ravindra Savaram is a Content Lead at His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter. Protection Status