PowerExchange for PostgreSQL User Guide for PowerCenter

10.5.9
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5.4
- 10.5.2
- 10.5
- 10.4.0

Back Next

Configure PostgreSQL Source Session Properties

You can configure the session properties for a PostgreSQL source on the

Workflow Manager

tab. Define the properties for the source instance in the session.

The following table describes the session properties that you can configure for a PostgreSQL source session:

Session Property	Description
Pre-SQL	The pre-SQL commands to run before the PowerCenter Integration Service reads data from the source. You can use the pre-SQL query to call a stored procedure in a PostgreSQL database.
Post-SQL	The post-SQL commands to run after the PowerCenter Integration Service reads data from source. You can use the post-SQL query to call a stored procedure in a PostgreSQL database.
SQL Override	The SQL statement to override the default query generated from the specified source type to read data from the PostgreSQL source. Ensure that the list of selected columns, data types, and the order of the columns that appear in the query matches the columns, data types, and order in which they appear in the source object. Note: SQL override is not supported when you enable partitioning. If you specify an SQL override and configure partitioning, the mapping fails.
Schema Name	Optional. Overrides the schema name of the source object. Ensure that the source table name and its metadata are identical. Otherwise, you might get an error that table does not exist under the specified overridden schema.
Filter Override Type	The type of filter expression that you want to override in the source qualifier. You can select Native or Platform filter expression type to override. Default is None.
Fetch Size	Determines the number of rows to read in one resultant set from PostgreSQL. Specifying a number limits the number of rows to fetch with each trip to the database and avoids unnecessary memory consumption. Default is 100000
Filter Override	The filter condition that overrides the filter condition you specify in the source qualifier. After you select Native or Platform Filter Override Type, specify the filter condition to override in the source qualifier. When you configure a Platform filter override, you must specify the absolute qualified column name in the following format: tablename.columnname

Rename Saved Search

Table of Contents

PowerExchange for PostgreSQL User Guide for PowerCenter

PowerExchange for PostgreSQL User Guide for PowerCenter

Configure PostgreSQL Source Session Properties

Configure PostgreSQL Source Session Properties