- PowerCenter 10.5.1
- All Products
Defines a custom query that replaces the default query the Integration Service uses to read data from sources represented in this Source Qualifier transformation. A custom query overrides entries for a custom join or a source filter.
Specifies the condition used to join data from multiple sources represented in the same Source Qualifier transformation.
Specifies the filter condition the Integration Service applies when querying rows.
Number of Sorted Ports
Indicates the number of columns used when sorting rows queried from relational sources. If you select this option, the Integration Service adds an ORDER BY to the default query when it reads source rows. The ORDER BY includes the number of ports specified, starting from the top of the transformation.
When selected, the database sort order must match the session sort order.
Sets the amount of detail included in the session log when you run a session containing this transformation.
Specifies if you want to select only unique rows. The Integration Service includes a SELECT DISTINCT statement if you choose this option.
Pre-session SQL commands to run against the source database before the Integration Service reads the source.
Post-session SQL commands to run against the source database after the Integration Service writes to the target.
Output is Deterministic
Relational source or transformation output that does not change between session runs when the input data is consistent between runs. When you configure this property, the Integration Service does not stage source data for recovery if transformations in the pipeline always produce repeatable data.
Output is Repeatable
Relational source or transformation output that is in the same order between session runs when the order of the input data is consistent. When output is deterministic and output is repeatable, the Integration Service does not stage source data for recovery.