Developer Tool Guide

Back Next

Entering a Source Filter

Enter a source filter to reduce the number of rows the Data Integration Service reads from the relational source.

Open the customized data object or the relational data object instance.

Select the

Read

view.

Select the Output transformation.

Select the

Query

properties.

Select the simple query.

Click

Edit

next to the

Filter

field.

The

SQL Query

dialog box appears.

Enter the filter condition in the

SQL Query

field.

You can select column names from the

Columns

list.

Click

Validate

to validate the filter condition.

Save the data object.

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.