The PowerCenter Client consists of applications that you use to design mappings and mapplets, create sessions and workflows to load the data, and monitor workflow progress.
In this tutorial, you learn about the following applications and tools:
PowerCenter Repository Manager.
Create a folder in the Repository Manager to store the metadata you create in the lessons.
PowerCenter Designer.
Create the source and the target definitions. Create mappings that contain transformation instructions for the PowerCenter Integration Service. In this tutorial, you learn about the following tools in the Designer:
Source Analyzer.
Import or create source definitions.
Target Designer.
Import or create target definitions. You also create tables in the target database based on the target definitions.
Mapping Designer.
Create mappings that the PowerCenter Integration Service uses to extract, transform, and load data.
Workflow Manager.
Create and run the workflows and the tasks in the Workflow Manager. A workflow is a set of instructions that describes how and when to run tasks to extract, transform, and load data.
Workflow Monitor.
Monitor scheduled and running workflows for each Integration Service.