PowerExchange for Db2 Warehouse User Guide for PowerCenter

Back Next

Importing Db2 Warehouse Target Definitions

To create a Db2 Warehouse target definition, use the Target Designer to import source metadata with the Db2 Warehouse relational data source.

In the Target Designer, click

Targets

Import from Database.

Select the Db2 Warehouse data source used to connect to the target database.

If you need to create or modify a Db2 Warehouse data source, click the

Browse

button to open the ODBC Administrator. Create the Db2 Warehouse data source and click

. Select the new Db2 Warehouse data source.

Enter the user name and password to connect 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. If you want to import tables for all the owners, click

All

Drill down through the list of database objects to view the available tables as targets.

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-consecutive selections. You can also use the

Select All

and

Select None

buttons to select or clear all available targets.

Click

OK.

The selected target definitions appear in the Navigator under the Targets node.

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.