Informatica Components Architecture
-The Repository Server manages the metadata in the repository database.
-The Repository Server manages connections to the repository from client applications.
-The Repository Service inserts, retrieves and updates metadata within the repository database tables. It strengthens the consistency within the repository.
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.
Informatica Components Overview
The following of the various business components which are placing a key role in developing data warehouse.
Informatics power center
Informatica power connect
Informatica power mart
Informatica power exchange
Informatica power analyses
Differences between Power Center and Power Mart
Informatica Power Center
It supposes to process a high volume of data
It supports ERP source such as SAP, PeopleSoft, etc...
It supports both global and local repositories
It can convert a local repository into global repository
Informatica Power Mart
It is recommended to process low volumes of data
It doesn’t support ERP sources such as SAP, people soft, etc
It supports local repository
There is no specialty to convert local to a global repository
Note:- An Informatica power center is a gui based ETL product from Informatica corporation.
A mapping logically defines extraction transformation and loading
A mapping is designed with the following components
It is the structure of the source table (or) file from which data will be extracted.
It is the structure of the target tables into which data loads.
It defines data transformation
A mapping is nothing but an ETL plan processing
Mapping design with source definition, target definition, and business logic
Odbc (Open data base connectivity)
An odbc is a middleware (or) an interface which allows you to access databases
Informatica Power Center 8.6 – components
When we install Informatica power center 8.6, the following component gets to install.
Power center clients
Power center repository
Power center domain
Web service hub
Power center administration console
Power Center Clients
The following are the power center clients are
Power center designer
Power center workflow manager
Power center work flow monitor
Power center repository manager
Power Center Designer
The designer is a GUI based client component that allows you to design a plane of ETL process known as mapping.
The designer allows you to create the following power center objects.
Design mapping with or without transformation Rule or logic
Power Center Workflow Manager
It is a GUI based client component which allows you to create the following power center objects.
Create a session for each mapping
Create a workflow to start sessions
A session is a power center object which runs mapping.
A session which makes mapping avail, i.e., for extraction, transformation, and loading
A session is a pointer to map
A workflow is known as “St task” which can run one or more sessions. The sessions can sequential (or) parallels.
Workflow can execute only no. ________ in sequentially
The top objects in the power center development hierarchy are workflow.
Power Center Workflow Monitor
It is a GUI based client component which allows you to monitor the session and workflow running on integration service.
It allows you to view session and work flow and session states
It allows you to fetch the session log from repository
Integration services is an ETL engine it perform ETL
Steps involving implementing ETL Process:-
Step 1. :- Creation of source definition
Step 2:- Creation of target definition
Step 3:- design a mapping with (or) without transformation rule Workflow manager
Step 4:- Create a session for each mapping
Step 5:- Create workflow
Step 6:- Start Workflow.
Power Center Repository Managers
It is a GUI-based administrative client that allows you to perform the following tasks.
Create, edit, delete folders
Assign, permission and permilizer to the users or user groups
Power Center Repository
The power center repository is a relational database, a system database which contains meta data which is required to perform extraction, transformation, and loading
The repository database consists of following the type of meta data objects.
The Repository is the brain of ETL system which contains “instructions” required to perform ETL. There are two types of repository can be created.
The metadata can be shared with in the repository
Repository service is a “multi-threaded” process that inserts, updates, delete and retrieves metadata from the repository.
The power center client applications access the repository through repository service.
The integration service accesses the repository through the repository service to read the metadata such as mapping and sessions.
The integration service also stores metadata such as session log, session, and workflow status in the repository through the repository service
The session log is created integration service.
The Integration Service is an ETL engine which performs extraction transformation, and loading
The integration service reads session and mappings from the repository.
It extracts the data from mapping sources, stored in a temporary memory called staging where it applies the transformation rules to process the data.
It loads transformed data into mapping targets
Success and failures and session logs are created integration service
Integration service ETL Process engine
Repository collection of tables that contains power center metadata
Repository services A centralized management of repository connection
Repository manager Performs repository security
Designer Create mapping objects
Workflow manager Create and start workflows
Workflow monitor and controls workflows
Repository services process Multi threaded process that retrieves, update, inserts, repository metadata.
Power Center Architecture:- Components
Sources:- It defines the extraction, it can be relational tables, flat files, XML files, cobal files, SAP, Oracle application, etc.
It defines the data loading, it can be relational tables (or) files.
The engine that performs extraction, transformation, and loading.
It manager connected to the metadata repository that contains mappings session and workflow definition.
Repository Services Process
A multi-threaded process that retrieves, inserts, and updates repository metadata.
It contains all of the metadata need to run ETL proc
Desktop tools used to populate the repository with metadata execute workflows and integrating service and monitory service and manage the repository.
Populate metadata means extraction transformation and loading mapping source workflow
Integration Service – Component
The integration service is created with three components.
It extracts the data from various types of sources the following are the types of readers
DTM (Data transformation manager)
It transforms the data according to the business logic that you configure in the mapping.
It inserts the data into a target system.
The following are the types of writers
Setup Source and Target Database
Start Programs oracle Application development
Client on SQL Plus.
Enter the following Logon details
Host string: ORCL
SQL > Create user batch 4:00 PM identified by target:
SQL> Grant DBA to Batch 4:00 PM;
SQL> Connect batch4:00PM / Target@ORCL;
SQL> Show user
Create table dim- employee (EMPNO Number(5),
Sal Number (7,2),
Deptno Number (5));
SQL> conn scott
Enter Password: *****
Creation of dob connections
Source odbc:- Procedures
Start settings control panel Administrative tools Datasources (odbc)
Select system DSN tab click on add
Select the driver oracle in ORADDBLOG-home click on finish
Enter the following details
Data source name: Batch 4:00 PM _ source_oracle
TNS Service Name: ORCL
User ID: SCOTT
Click on Test connection
Enter password: Tiger click ok
Target odbc:- procedure:
From system, DSN Tab click on Add
Select the driver oracle in oraDblog-home1
Click on finish.
Data source name: Batch 4:00 PM – target –oracle
TNS service Name: ORCL
Userid : Batch 4:00 PM
Click on test connection
Enter password: Target click ok
Start settings control panel administrative tools services
Start the following services
Informatica orchestration service
Informatica services 8.6.0
Creation of folder
A folder is a power center object which allows you to organize the metadata stored in the repository.
For in-depth understanding of Informatica click on
- Data Mart and Types of Data Marts
- Informatica Tutorials & Interview Questions
- Informatica Components Overview
- Variable Ports in Informatica
- Informatica Power Center 8.6 Installation