PowerExchange for JDBC V2 User Guide

Back Next

Query Properties

Use the query property to select specific records from the database that you are connected to.

The following table describes the query properties that you configure for a data object read operation:

Property	Description
Join	The Join expression in a read operation to join data from multiple tables. Select more than one source in the Data Object tab and define the join condition in the Query tab.
Filter	The Filter value in a read operation. The filter specifies the where clause of select statement. Use a filter to reduce the number of rows that the Data Integration Service reads from the source. When you enter a source filter, the Developer tool adds a WHERE clause to the default query. You can use the Native or Platform expression to select specific records.