Configure filters on the

Connect Source

page under

Define Filters

. To add filters, click

+

in the

Filter Conditions

area. In the

Configure Filters

dialog box, select the source object and configure one or more filter conditions.

This image shows the

Configure Filter

dialog box:

To add a filter condition, click the plus sign (

+

) icon. Each filter condition contains a field, operator, and value. You can use the following operators in a filter condition:

Enter date values in the format YYYY-MM-DD HH24:MI:SS.

If you add multiple filter conditions, the task evaluates the filter conditions in the order in which they appear in the

Configure Filters

dialog box.

For example, you want to extract records from the Orders table only when the city is New York and the order date is later than January 1, 1990. Select "Orders" as the source object, and configure the following filter conditions:

The

Filter Conditions

area displays the filters you added for each source object. To update the filters for a source object, click the filters in the row that contains the source object. To delete all filters for a source object, click the

Delete

icon in the row that contains the source object.