Informatica Architecture

INFORMATICA ARCHITECTURE : 

Informatica Architecture is divided into two components:

1. Server Components -->Server Components in Informatica are:

a. Repository Server

b. Informatica Server

2. Client Components --> Client Components in Informatica are:

a. Workflow Designer

b. Workflow Manager

c. Workflow Monitor

d. Repository Manager

Here is the Architecture Flow Diagram of Informatica:

Now, let`s talk about the flow in detail: A developer writes a program in the Designer. The program is a GUI-Based program and is called Mapping. Once the mapping is created, the mapping needs to be saved into the repository. Once the program(mapping) is saved, the next step is to execute the program. To execute the program WorkFlow Manager tool is required. You cannot execute the mapping directly, you need to create a session task for the mapping. Once the session task is created it needs to be saved into the repository. Also, you cannot execute the session task directly. For execution you need to create a Workflow using the Workflow Manager tool. Once created you need to save the workflow to the repository. Workflow will be executed from the workflow manager. During the execution of the workflow, you can monitor the activities using the WorkFlow Monitor.

Other  important components of the informatica power center are listed below:

Domain: Domain is the primary unit for management and administration of services in Powercenter. The components of domain are one or more nodes, service manager an application services.

Node: Node is logical representation of machine in a domain. A domain can have multiple nodes. Master gateway node is the one that hosts the domain. You can configure nodes to run application services like integration service or repository service. All requests from other nodes go through the master gateway node.

Service Manager: Service manager is for supporting the domain and the application services. The Service Manager runs on each node in the domain. The Service Manager starts and runs the application services on a machine.

Application services: Group of services which represents the informatica server based functionality. Application services include powercenter repository service, integration service, Data integration service, Metadata manage service etc.

Powercenter Repository: The metadata is store in a relational database. The tables contain the instructions to extract, transform and load data.

Powercenter Repository service: Accepts requests from the client to create and modify the metadata in the repository. It also accepts requests from the integration service for metadata to run workflows.

Powercenter Integration Service: The integration service extracts data from the source, transforms the data as per the instructions coded in the workflow and loads the data into the targets.

Informatica Administrator: Web application used to administer the domain and powercenter security.

Metadata Manager Service: Runs the metadata manager web application. You can analyze the metadata from various metadata repositories.

Thanks & Regards

        D Sagar

Introduction of dsag_informatica_complete_guide blog

Hi  Guys,

This is Sagar working as a Informatica developer since 3.5 years. Whatever I've learned, want to share it with you guys.
This blog is created to discuss the concepts, scenario of Informatica Powercenter which is one of the most popular ETL tools. 
Along with these we will discuss about how to prepare for interview for freshers as well as for the experienced candidates also.

I hope this blog will helps you a lot.

Your appreciations, doubts  as well as any mistake indications will always well-come.

Thank you so much in Advance

Regards
D Sagar