Saturday, 5 November 2016

Components of Informatica PowerCenter - Architecture

Informatica PowerCenter Architecture:

When we install Informatica PowerCenter, the following 2 types of components gets installed.
  • Client Components
  • Server Components

Client Components are:
  • Informatica PowerCenter Designer
  • Informatica PowerCenter workflow manager
  • Informatica PowerCenter monitor and
  • Informatica PowerCenter Repository manager

Server Components are:
  • Repository Services
  • Integration Services

Informatica PowerCenter Designer:

It is a GUI based client component which is used to import source definition, target definition, design mappings, to design mapplets and to create reusable transformations etc.,

It contains 5 tools.

1. Source Analyzer:
It is used to import source meta data.

2. Target Designer:
It is used to import target meta data and to design the target tables at Informatica level.

3. Mapplet Designer:
It is used to design mapplets(Reusable Objects created with set of transformations)

4. Transformation Developer:
It is used to create reusable transformations created with single transformation.

5.Mapping Designer:
It is used to create or design mappings in Informatica.

Designer Client connects to the source and target databases using ODBC connection to import the meta data.


Workflow Manager:

It is a GUI based client component which is used to create relational connections, to create different types of tasks like session, email, command, event wait, event raise.
It is also used to create worklets(reusable objects with set of tasks) and to design workflow.
Workflow Manager contains 3 tools as follows:
1. Task Developer:
It is mainly used to create reusable tasks.
The following 3 tasks can be developed using task developer.

  • Session Task
  • Email Task
  • command Task
2. Worklet Designer:
It is used to create worklets.

3. Workflow Designer:
It is used create workflows.


Relational Connections:

It is an connection object which contains Database information. Informatica Server connects to source and target databases with the help of Relational Connection at the time of execution.

Session Task:
It is an object which provides a set of instructions  or required information like mapping information, connection info, load type info, parameter file path etc.,
A session task is required to execute a mapping. One session can take only 1 mapping for execution.

It is a top level object in Informatica PowerCenter which is used to execute different types of tasks. One workflow can have any number of tasks. By default, every workflow is created with start button.
Use Link task to connect multiple tasks while creating the work flow.

Workflow Monitor:

It is a GUI based client component which is used to monitor the workflows at the time of execution to know the status whether it is succeeded or failed or running.
It is also used to display the run properties like source success rows, source fail rows, target success rows and failed rows etc.,
Workflow monitor allows the user to open session logs and workflow logs to give the events occurred at the time of execution.
Workflow monitor can send a request to informatica server for execution.

Repository Manager:

Repository Manager is used to perform admin roles like creating folders in the repository, deleting the folders, editing the folders, exporting the objects, importing the objects etc.,

Server Components:
  1. Repository Service
  2. Integration Service
Repository Service:
There is a two way communication between all the client components and repository database through repository services.

Integration Service:
It is the main services which executes the ETL objects developed by Informatica clients. Integration Service executes the workflow as soon as it receives the request from client. Integration Service performs extraction, transformation and loading according to the plan available in the mapping.

No comments:

Post a Comment