Informatica 9x Architecture
Informatica is an ETL tool
used for extracting the data from various sources (flat files, relational
database, xml etc), transform the data and finally load the data into a
centralized location such as data warehouse or operational data store.
Informatica powercenter has a
service oriented architecture (SOA) that provides the ability to scale services
and share resources across multiple machines.
The architectural diagram of
Informatica is shown below:
Logical
Diagram:
Note:
The Blue part is same as version 8 and the green part is new in 9
Informatica PowerCenter Architecture:
Physical
Diagram:
The important components of the Informatica powercenter are listed below:
Informatica Administrator: Web application used to administer the domain and powercenter security.
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.
This is very good information
ReplyDeleteinformatica online training, informatica training in bangalore, informaitca training
Deleteit was a nice article and it was very helpfulInformatica Training in Chennai|Informatica MDM Training in Chennai|Informatica Data Quality Training in Chennai|SEO Training in Chennai|
It was really a nice article and i was really impressed by reading this Informatica Online Course Bangalore
ReplyDeleteThank you for sharing wonderful information with us to get some idea about it.
ReplyDeleteETL Testing Certification
ETL Testing Course in Hyderabad
A good unique article in reference to the information shared. Good work.
ReplyDeleteThanks For Information.
ReplyDeleteIT Company in Jabalpur
On a smaller scale, it is easy to get overwhelmed by the sheer amount of data we produce. As humans, we have a strong desire to simplify and categorize things, so we can better understand them. WhatBig Data represents is a situation in which this approach does not work. Social networks, blogs, and even
ReplyDeleteThank You for Sharing this wonderful and much required information in this post.
ReplyDeleteVisit us: Dot Net Training Online India
Visit us: .Net Online Training Hyderabad
It is so nice article thank you for sharing this valuable content.
ReplyDeleteworkday online integration course
workday online integration course in india
I truly appreciate the time and work you put into sharing your knowledge. I found this topic to be quite effective and beneficial to me. Thank you very much for sharing. Continue to blog.
ReplyDeleteData Engineering Services
AI & ML Solutions
Data Analytics Services
Data Modernization Services
This comment has been removed by the author.
ReplyDeleteIt is so nice article thank you for sharing this valuable content.
ReplyDeleteerp software companies
amazing post, Python Course In Amravati
ReplyDelete