English
  • PowerCenter 10.4.0
  • All Products

Table of Contents

Search

  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  16. Datatype Reference
  17. Configure the Web Browser

Designer Guide

Designer Guide

Back Next

Importing Relational Target Definitions

Importing Relational Target Definitions

To create a relational target definition, use the Target Designer to import target metadata.
To import a relational target definition:
  1. In the Target Designer, click Targets > Import from Database.
  2. Select the ODBC data source used to connect to the target database.
    If you need to create or modify an ODBC data source first, click the Browse button to open the ODBC Administrator. After creating or modifying the ODBC source, continue with the following steps.
  3. Enter the user name and password needed to open a connection to the database, and click Connect.
    If you are not the owner of the table you want to use as a target, specify the owner name.
  4. Drill down through the list of database objects to view the available tables as targets.
  5. Select the relational table or tables to import the definitions into the repository.
    You can hold down the Shift key to select a block of tables, or hold down the Ctrl key to make non-contiguous selections. You can also use the Select All and Select None buttons to select or clear all available targets.
  6. Click OK.
    The selected target definitions now appear in the Navigator under the Targets icon.