PowerExchange for PeopleSoft User Guide for PowerCenter

10.5.7
- 10.5.8
- 10.5.6
- 10.5.4
- 10.5
- 10.4.0

Back Next

Viewing the Default Query

You can view the default query for PeopleSoft records in the Application Source Qualifier transformation. For accurate results, connect all the input and output ports you want to use in the mapping before generating the query.

To view the default query for PeopleSoft records:

From the Properties tab, select Extract Override.

The SQL Editor appears.

If a source definition for a PeopleSoft tree is connected to or associated with the Application Source Qualifier transformation, the Extract Override option is disabled.

Select Generate SQL.

Unless you change or override this query, the PowerCenter Integration Service uses this query to generate the extract query.

Click Cancel to exit.

If you do not cancel the extract override, the PowerCenter Integration Service uses the resulting query. It ignores subsequent changes you make to the transformation and does not perform automatic language code translations.

Rename Saved Search

Table of Contents

PowerExchange for PeopleSoft User Guide for PowerCenter

PowerExchange for PeopleSoft User Guide for PowerCenter

Viewing the Default Query

Viewing the Default Query