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.
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:
Import or create source definitions.
Import or create target definitions. You also create tables in the target database based on the target definitions.
Create mappings that the PowerCenter Integration Service uses to extract, transform, and load data.
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.
Monitor scheduled and running workflows for each Integration Service.