Informatica PowerCenter has been a leader in the Gartner Magic Quadrant for Data Integration technology for the past ten years. It is also one of the most sought-after skills in today’s IT market, as it is a unique data integration platform that interoperates over broad ranges of various applications and systems. In this Informatica tutorial, you will understand why there is so much buzz around Informatica and most importantly what is Informatica, its architecture, and Informatica installation.
|Here in this tutorial, you will learn|
Informatica is a company that offers the market’s leading Enterprise Cloud Data Management and Data Integration products. Primarily utilized for retrieving and analyzing data from various data sources to build enterprise data warehouse applications.
Informatica is also known as Informatica PowerCenter. This tool mainly focuses on ETL, data masking, data replication, data quality, data virtualization, and much more. It offers services for various industries, businesses, and government organizations including healthcare, telecommunication, insurance, and financial services.
|Related Article: What is Informatica Power Center|
The Informatica editions available in the market are:
To get a deep dive into Informatica, we must have a better understanding of ETL.
<iframe width="956" height="538" src="https://www.youtube.com/embed/am87TLoRIRM" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>
|If you want to enrich your career and become a professional in Informatica, then Enrol Our "Informatica Course Online". This course will help you to achieve excellence in this domain.|
ETL is defined as the process of moving data from its source to the data storage system.
|Related Article: Informatica ETL Tool|
The following are the major features supported by Informatica:
Informatica is the most widely used data integration tool today. The reasons behind why Informatica is the best solution in enterprises are:
To gain more in-depth knowledge of Informatica in real-time, we should have a clear understanding of Informatica Architecture and its components.
Informatica has a service-oriented architecture. A service-oriented architecture is nothing but two or more services that communicate with each other for data transfer. Informatica PowerCenter follows component-based development methodologies to build data flow from source to target using various components called transformations.
|Related Article: Transformations in Informatica|
|Related Article: Architecture of Informatica|
Informatica Domain is the primary administrative unit of PowerCenter. It consists of a set of nodes and services. Further, they are subdivided into folders and subfolders based on design architecture and administration requirements.
There are two types of services available in the Informatica Domain:
The Domain configuration is done using the Informatica Admin console and it can be launched using web programs. Once the installation is done, it prompts the administrator to log in.
These properties can be changed based upon the requirement.
|Related Article: Informatica Scenario Based Questions|
A node is the logical representation of a machine/server in the domain. There are multiple nodes available in the domain. The master gateway node is the one that hosts the Informatica domain and it is the entry point to the domain.
A node has physical attributes such as the Port Number and Hostname. It also runs a service manager for application and core services.
Informatica consists of two components, namely:
Repository Service: It manages the metadata in the repository database and repository connection requests from client applications. It also monitors the status of Repository Agents. The Repository Agent is a separate multi-threaded process that recovers, inserts, and updates metadata in the repository database tables.
Web Services Hub: It is a gateway to showcase the PowerCenter functionality for external clients.
SAP BW Services: It looks out for RFC requests from SAP BW and commences workflows to extract data from, or load data into SAP BW.
Repository Manager is used for administering repositories and perform folder functions like create, edit, and delete folders. It also manages users and groups. You can also assign and invoke repository privileges and folder permissions, view lock, and unlock objects.
The repository manager consists of the following:
A designer is used to import or create a target definition. Informatica designer is the client where we decide how to move data between various sources and targets. It is used for creating source definitions, transformations, target definitions, and further to develop mappings.
It is used to create a workflow (set of instructions) to execute mappings. The workflow includes sessions and other tasks that are used for accomplishing the overall operational purpose. Workflows are built and run through workflow manager in the PowerCenter application. Workflow designer maps the execution order and dependencies of Worklets, sessions, and tasks for the Informatica server.
It monitors workflows and tasks. Details of workflow or task can be viewed in either Task view or Gantt view. We can run, abort, stop, and resume workflows. The workflow monitor showcases workflows that runs at least once. It continuously receives information from the repository service and integration services. It also fetches information to display historic information from the repository.
Informatica Administration Console is the administration tool used for both the Informatica security and the Informatica domain.
The tasks performed by the Informatica Administrator Console are:
Use WinRAR for extracting files, as other file explorers can cause an error while extracting dac_win_11g_infa_win_64bit_961.
We have verified that the current system meets installation requirements, now we proceed with the actual installation process.
Go to the extracted directory 961_Server_Installer_winem-64t and double click on install.bat file and click on start.
Now, it will take a bit of time to install the software.
In this tutorial, you have learned what exactly Informatica is all about, including the various components involved in it and its installation process. We hope this information was quite helpful for you to build a strong foundation for Informatica.
Madhuri is a Senior Content Creator at MindMajix. She has written about a range of different topics on various technologies, which include, Splunk, Tensorflow, Selenium, and CEH. She spends most of her time researching on technology, and startups. Connect with her via LinkedIn and Twitter .