PowerCenter - Integration Service
1 - About
The PowerCenter Integration Service is an application service that runs workflows and sessions for the PowerCenter Client.
The Integration Service reads workflow information from the repository. The Integration Service connects to the repository through the repository service to fetch metadata from the repository (what about BDM - Model Repository Service (MRS) ?)
A workflow is a set of instructions that describes how and when to run tasks related to extracting, transforming, and loading data. The Integration Service runs workflow tasks. A session is a type of workflow task. A session is a set of instructions that describes how to move data from sources to targets using a mapping.
The Integration Service loads the transformed data into the mapping targets.
The Integration Service can combine data from different platforms and source types. For example, you can join data from a flat file and an Oracle source. The Integration Service can also load data to different platforms and target types.