Table of Contents

Search

  1. Preface
  2. Product Overview
  3. Before You Begin
  4. Tutorial Lesson 1
  5. Tutorial Lesson 2
  6. Tutorial Lesson 3
  7. Tutorial Lesson 4
  8. Tutorial Lesson 5
  9. Tutorial Lesson 6
  10. Appendix A: Naming Conventions
  11. Appendix B: Glossary

Getting Started

Getting Started

Using the PowerCenter Client in the Tutorial

Using the PowerCenter Client in the Tutorial

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.

0 COMMENTS

We’d like to hear from you!