Informatica 9.x Architecture

•  
  
•   Administrator Console: This is a web based platform where an administrator can control how Informatica will be setup. This involves setting up and maintenance of domain, nodes, and various services such as Repository Service, Integration Service. This tool also provides Security Control like adding groups, users and their access to repository. 

• Informatica Services Platform (ISP): The ISP is the administrative framework for Informatica services. It allows monitoring, start/stop, and failover of services. It provides a set of core services used internally, like Authentication Service, Name Services, and so on.

•  Integration Service (IS): Integration service is created while installing Power Center and then we can manage IS using Administrator console. IS reads workflow information from Repository by requesting Repository service to run workflow. When we run the workflow, IS locks the workflow and then executes tasks, sessions related to that workflow. IS loads the extracted data into mapping target/s, also executes pre and post session commands, and email notification.

• Repository & Repository Service:

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.

• Metadata Manager Service: Metadata Manager interacts with Repository service via Metadata Manager Service.

• Data Integration Service (DIS): DIS is the container for all data integration functionalities. DIS plug-ins provides different data integration functionalities. The different plug-ins are as follows:

     Profiling service plug-in translates profile into mappings. 

     SQL Service plug-in translates SQL into mappings

     Mapping Service executes data quality plans

• Data Transformation Manager (DTM): DTM Interprets and executes mappings. It is re-engineered to be lightweight and embeddable. It allows repository-less execution: In previous versions of PowerCenter, DTM connects to the repository to fetch the plan. However, now the mapping can be run without reading from the repository, like mapping stored to disk. DTM enables concurrent execution semantics: multiple DTM instances can coexist in the same process. It supports logical transforms, which are translated to executable transforms before execution. It allows different execution modes: single threaded and pipelined execution modes. DTM comes up with optimal execution plan for mappings.

• Informatica Analyst: According to Informatica documentation:

Informatica Analyst is a web-based application client that analysts can use to analyze, cleanse, standardize, profile, and score data in an enterprise. Business analysts and developers use Informatica Analyst for data-driven collaboration. You can perform column and rule profiling, score carding, and bad record and duplicate record management.

• Informatica Developer: It is an application client that developers use to design and implement data quality and data services solutions.

For more about Integration Service

Thank you…