-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.
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
Informatica power quality
Differences between Power Center and Power Mart
Informatica Power Center
It suppose to process high volume of data
It support 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 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 design 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