PowerExchange for PeopleSoft User Guide for PowerCenter

10.5
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5.4
- 10.4.0

Back Next

Editing PeopleSoft Source Definitions

You can edit a PeopleSoft source definition to add descriptions or accommodate minor changes to the source. You can change source or port names, enter descriptions, change the port order, or delete ports. You can also change key types for PeopleSoft records to create primary-foreign key relationships.

Because source definitions must match the source, import definitions instead of creating them manually.

To edit a PeopleSoft source definition:

In the Source Analyzer, double-click the title bar of the source definition.

Edit the following settings:

Table Settings	Description
Select Table	Displays the source definition you are editing. To choose a different open source definition to edit, select it from the menu.
Rename button	Opens a dialog box to edit the following properties: Source name Database name Business name
Owner Name	Owner of the business component or table.
Description	Description of the source definition.

Click the Columns tab.

From the Columns tab, you can edit column names, datatypes, key types, and other properties.

Click the Metadata Extensions tab.

From the Metadata Extensions tab, you can add, remove, or edit metadata extension names, datatypes, key types, and other restrictions.

Rename Saved Search

Table of Contents

PowerExchange for PeopleSoft User Guide for PowerCenter

PowerExchange for PeopleSoft User Guide for PowerCenter

Editing PeopleSoft Source Definitions

Editing PeopleSoft Source Definitions