PowerExchange for PeopleSoft User Guide for PowerCenter

10.5.8
- 10.5.7
- 10.5.6
- 10.5.4
- 10.5
- 10.4.0

Back Next

Creating an Extract Override

To incorporate configured transformation options in the Application Source Qualifier in an extract override, generate and customize the default query. Before generating the default query, connect the Application Source Qualifier transformation to all subsequent transformations. The Designer uses both connected input and output ports to generate the appropriate extract query.

Once you enter an extract override, the Designer accepts the override and ignores any subsequent changes you might make to the Application Source Qualifier transformation. The PowerCenter Integration Service uses the extract override to query sources.

When you enter an extract override, the PowerCenter Integration Service does not perform language code queries. It ignores any language code entered in the session database connection.

To create and validate an extract override:

In the Mapping Developer, edit an Application Source Qualifier transformation, and select the Properties tab.

Click the right corner of the Extract Override option to open the Source Editor.

To use existing transformation properties in the override, click Generate SQL, and then edit the extract query.

To ignore any existing transformation configurations, enter the extract override. Use SQL syntax supported by the underlying database for the PeopleSoft source system.

Use database table names in the extract override. Database table names for PeopleSoft record sources typically begin with PS_. For example, the database table name for the PeopleSoft record PROJ_MILE_TBL is PS_PROJ_MILE_TBL.

Select port names from the Ports tab to ensure the database table name is correct.

To validate extract override syntax, select the ODBC data source used to connect to the source database, enter the database username and password and click Validate.

The Designer connects to the source database and tests the query syntax. The Designer displays a message stating whether the syntax is valid.

Click OK to save the query and return to the Edit Transformations dialog box.

Click OK again to return to the Designer.

The Designer replaces the default query with the extract override. The PowerCenter Integration Service uses this override to query sources unless you update or delete the extract override. The PowerCenter Integration Service does not append language code queries to an extract override.

Rename Saved Search

Table of Contents

PowerExchange for PeopleSoft User Guide for PowerCenter

PowerExchange for PeopleSoft User Guide for PowerCenter

Creating an Extract Override

Creating an Extract Override