Informatica architecture is service-oriented architecture (SOA). A service-oriented architecture is defined as a gaggle of services that communicate with one another . It means an easy data transfer during this communication, or it are often two or more services that coordinate an equivalent activity.

The Informatica development depends upon the component-based development techniques. this system uses the predefined components and functional units with their functionalities to urge the result.

PowerCenter is predicated on the component-based development methodologies. to create a dataflow from the source to focus on, it used different components, and this process is named transformation.

Informatica ETL tool has the below services and components, such as:

Repository Service: it’s liable for maintaining Informatica metadata and provides access to an equivalent to other services.
Integration Service: This service helps within the movement of knowledge from sources to the targets.
Reporting Service: This service generates the reports.
Nodes: this is often a computing platform to execute the above services.
Informatica Designer: It creates the mappings between source and target.
Workflow Manager: it’s wont to create workflows or other tasks and their execution.
Workflow Monitor: it’s wont to monitor the execution of workflows.
Repository Manager: it’s wont to manage the objects within the repository.

Informatica Domain

The Informatica domain is that the fundamental administrative body.
The Informatica domain consists of nodes and services. These nodes and services are categorized into folders or sub-folders supported administration requirements and style architecture.
The Console website of the Informatica administrator creates a website that appears sort of a folder. Inside this folder, we will create a node with the services.
In the Informatica domain, a node may be a logical representation of the machine. All the services and processes run inside the domain within the Informatica. Multiple nodes are often present during a single domain. A gateway node receives the request from the clients and guides them to their respective services.
The domain provides two sorts of services, such as:

Service Manager: It manages domain operations like logging, authentication, and authorization. It runs the appliance services on the nodes and leads users and groups.
Application Services: It represents the server-specific services like repository services, reporting services, and integration services. the appliance service can run on different nodes supported configuration.

Node

Node may be a sensible study of a machine during a domain, and a website has different hubs. To run the appliance administrations, we will design the hubs, like mix administration.

PowerCenter Repository

The PowerCenter repository may be a electronic database like SQL Server, Oracle, and Sybase. And these databases are maintained by the repository services. The database tables store the metadata.

Informatica client tools are the three types, such as:

Informatica designer
Informatica workflow manager
Informatica workflow monitor

Informatica provides repository services, and it’s wont to manage the repository. The repository services exclusively handle one request for one repository. But we will execute it on multiple nodes for better performance.

We can maintain the various versions of an equivalent objects due to its version control mechanism. And also ignore multiple users that modifying an equivalent object at an equivalent time.

The objects created within the repository are having this three-state, such as:

Valid: Valid objects have the right syntax, consistent with the Informatica. And used for the execution of the workflow.
Invalid: Invalid objects don’t follow the quality or rules. These objects checked the syntax, and properties are valid or not during the saving of the thing in Informatica.
Impacted: the kid objects of the affected object are invalid.

PowerCenter Repository Service

PowerCenter repository service may be a different multi-strung process. It allows the customer to vary the metadata within the store. It accepts demands from the considerate benefit for metadata to run work processes.

And the repository service maintains the associations from PowerCenter customers to the PowerCenter vault. It inserts the metadata inside the archive and keeps it refreshed. it’s ready to continue consistency inside the archive metadata.

Domain configuration

In the Informatica ETL tool, the domain is that the necessary fundamental administrative control. it’s a clear entity that gives other different services like repository service, integration service, and various nodes.

The Informatica admin console is employed for the domain configuration. and therefore, the console is launched with the assistance of the online browsers.

PowerCenter Client and Server Connectivity

PowerCenter client tools are installed on the client-side machines. These tools are the event tools like workflow manager, PowerCenter designer, repository manager, and workflow monitor.

Informatica repository contains all the created mapping and objects in these client tools, which resides on the Informatica server. That’s why client tools must have network connectivity with the server.

Also, PowerCenter client connects to the sources and targets to import the metadata and structure definitions. Thus, it also maintains the connectivity to the source or target systems.

PowerCenter client uses the TCP/IP protocols for connectivity with the mixing service and repository service.
And PowerCenter client uses the ODBC drivers for the connectivity with the source or targets.

Repository Service

The repository service may be a multithreading process. It maintains the connection between the PowerCenter clients and therefore the PowerCenter repository.

The repository service can fetch, insert, and update the metadata inside the repository. And it also maintains the consistency inside the repository metadata.

Integration Service

The integration service is employed as an execution engine within the Informatica. It helps in executing the tasks which are created within the Informatica. Integration service works within the following manner, such as:

A user performs a workflow.
The Informatica instructs the mixing service to execute the workflow.
Then the mixing service reads workflow details from the repository.
The integration service starts the execution of the tasks inside the workflow.
After the execution, the task status is updated, for instance, Succeeded, Failed, or Aborted.
Then it grants the session log and workflow log.
This service loads the info into the target systems.
Integration service combines data from different sources.

So, this brings us to the end of blog. This Tecklearn ‘Informatica Architecture’ blog helps you with commonly asked questions if you are looking out for a job in Informatica. If you wish to learn Informatica and build a career in Datawarehouse and ETL domain, then check out our interactive, Informatica Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

https://www.tecklearn.com/course/informatica-training-and-certification/

Informatica Training

About the Course

Tecklearn’s Informatica Training will help you master Data Integration concepts such as ETL and Data Mining using Informatica PowerCenter. It will also make you proficient in Advanced Transformations, Informatica Architecture, Data Migration, Performance Tuning, Installation & Configuration of Informatica PowerCenter. You will get trained in Workflow Informatica, data warehousing, Repository Management and other processes.

Why Should you take Informatica Training?

Informatica professionals earn up to $130,000 per year – Indeed.com
GE, eBay, PayPal, FedEx, EMC, Siemens, BNY Mellon & other top Fortune 500 companies use Informatica.
Key advantages of Informatica PowerCenter: Excellent GUI interfaces for Administration, ETL Design, Job Scheduling, Session monitoring, Debugging, etc.

What you will Learn in this Course?

Informatica PowerCenter 10 – An Overview

Informatica & Informatica Product Suite
Informatica PowerCenter as ETL Tool
Informatica PowerCenter Architecture
Component-based development techniques

Data Integration and Data Warehousing Fundamentals

Data Integration Concepts
Data Profile and Data Quality Management
ETL and ETL architecture
Brief on Data Warehousing

Informatica Installation and Configuration

Configuring the Informatica tool
How to install the Informatica operational administration activities and integration services

Informatica PowerCenter Transformations

Visualize PowerCenter Client Tools
Data Flow
Create and Execute Mapping
Transformations and their usage
Hands On

Informatica PowerCenter Tasks & Workflows

Informatica PowerCenter Workflow Manager
Reusability and Scheduling in Workflow Manager
Workflow Task and job handling
Flow within a Workflow
Components of Workflow Monitor

Advanced Transformations

Look Up Transformation
Active and Passive Transformation
Joiner Transformation
Types of Caches
Hands On

More Advanced Transformations – SQL (Pre-SQL and Post-SQL)

Load Types – Bulk, Normal
Reusable and Non-Reusable Sessions
Categories for Transformation
Various Types of Transformation – Filter, Expression, Update Strategy, Sorter, Router, XML, HTTP, Transaction Control

Various Types of Transformation – Rank, Union, Stored Procedure

Error Handling and Recovery in Informatica
High Availability and Failover in Informatica
Best Practices in Informatica
Debugger
Performance Tuning

Performance Tuning, Design Principles & Caches

Performance Tuning Methodology
Mapping design tips & tricks
Caching & Memory Optimization
Partition & Pushdown Optimization
Design Principles & Best Practices

Informatica PowerCenter Repository Management

Repository Manager tool (functionalities, create and delete, migrate components)
PowerCenter Repository Maintenance

Informatica Administration & Security

Features of PowerCenter 10
Overview of the PowerCenter Administration Console
Integration and repository service properties
Services in the Administration Console (services, handle locks)
Users and groups

Command Line Utilities

Infacmd, infasetup, pmcmd, pmrep
Automate tasks via command-line programs

More Advanced Transformations – XML

Java Transformation
HTTP Transformation

Got a question for us? Please mention it in the comments section and we will get back to you.

520