PowerExchange for Db2 Warehouse User Guide for PowerCenter

10.4.0
- 10.5.7
- 10.5.6
- 10.5.4
- 10.5.1
- 10.5
- 10.4.1

Back Next

Source Qualifier Properties

You can configure source qualifier properties to sort the number of input ports and to retrieve distinct data from a Db2 Warehouse source. You can override the values in the session properties.

The following table describes the source qualifier properties:

Source Options	Description
Select Distinct	Selects unique values. Db2 Warehouse ignores trailing spaces. Therefore, the PowerCenter Integration Service might extract fewer rows than expected.
Source Filter	Reduces the number of rows the PowerCenter Integration Service queries. Use the following syntax: <table name>.”<field name>” <operator> <value> The filter condition is case sensitive.
Number of Sorted Ports	Number of columns used when sorting rows queried from the source. The PowerCenter Integration Service adds an ORDER BY clause to the default query when it reads source rows. The ORDER BY clause includes the number of ports specified, starting from the top of the transformation. When you specify the number of sorted ports, the database sort order must match the session sort order. Default is 0.
SQL Query	Overrides the default query. Enclose column names in double quotes. The SQL query is case sensitive.

Rename Saved Search

Table of Contents

PowerExchange for Db2 Warehouse User Guide for PowerCenter

PowerExchange for Db2 Warehouse User Guide for PowerCenter

Source Qualifier Properties

Source Qualifier Properties