Monday, March 20, 2017

Informatica PowerCenter 9 Architecture


Informatica PowerCenter 9 Architecture




Before we learn how to use Informatica, we need to understand what are the important components of Informatica and how it works.
Informatica tool consists of following services & components
1.Repository Service – Responsible for maintaining Informatica metadata & providing access of same to other services.
2.Integration Service – Responsible for the movement of data from sources to targets
3.Reporting Service - Enables the generation of reports
4.Nodes – Computing platform where the above services are executed
5.      Informatica Designer - Used for creation of mappings between source and target
6.      Workflow Manager – Used to create workflows and other task & their execution
7.      Workflow Monitor – Used to monitor the execution of workflows

8.      Repository Manager – Used to manage objects in repository


Informatica Repository:
The informatica repository is at the center of the informatica suite.
·        The Informatica repository is a relational database that stores information, or metadata, used by the Informatica Server and Client tools.
·        Metadata is data about data which include information such as source definitions , target definitions, mappings describing how to transform source data, sessions indicating when you want the Informatica Server to perform the transformations, and connect strings for sources and targets. 
·        The repository also stores administrative information such as usernames and passwords, permissions and privileges, and product version. 
·        Use repository manager to create the repository. The Repository Manager connects to the repository database and runs the code needed to create the repository tables. These tables stores metadata in specific format the informatica server, client tools use. 



Informatica Repository:
The informatica repository is at the center of the informatica suite.
·        The Informatica repository is a relational database that stores information, or metadata, used by the Informatica Server and Client tools.
·        Metadata is data about data which include information such as source definitions , target definitions, mappings describing how to transform source data, sessions indicating when you want the Informatica Server to perform the transformations, and connect strings for sources and targets. 
·        The repository also stores administrative information such as usernames and passwords, permissions and privileges, and product version. 
·        Use repository manager to create the repository. The Repository Manager connects to the repository database and runs the code needed to create the repository tables. These tables stores metadata in specific format the informatica server, client tools use. 
 Informatica Components: 
Server Components:
  1. Repository Service
  2. Integration Service

Client Components:
  1. Repository Manager
  2. Designer
  3. Workflow Manager
  4. Workflow Monitor

Server Components 
1. Repository Server:
Ø      The Repository Server manages the metadata in the repository database.
Ø      The Repository Server manages connections to the repository from client applications.
Ø      The Repository Service is a separate, multi-threaded process that retrieves, inserts, and updates metadata in the repository database tables. The Repository Service ensures the consistency of metadata in the repository.

2. Integration Service:
Ø      The Integration Server reads mapping and session information from the repository. It extracts data from the mapping sources and stores the data in memory while it applies the transformation rules that you configure in the mapping. The Integration Server loads the transformed data into the mapping targets.
Ø      Manages the scheduling and execution of workflows
Ø      The Integration Server can start and run multiple workflows concurrently. It can also concurrently process partitions within a single session. 


2 comments:

  1. Learned a lot of new things from your post! Good creation and HATS OFF to the creativity of your mind. Very interesting and useful blog! Informatica Training in Chennai
    Informatica Training Institute in Chennai

    ReplyDelete
  2. I think Informatica and its tools are actually the best whenever it comes to solving some very tough and complex IT problems.

    Informatica Read SOAP API

    ReplyDelete

DATABRICKS Pyspark Important

 ================DUPLICATE=============== # Define a Window specification window_spec = Window.partitionBy(*columns_to_check).orderBy("...