Source Queries

Filter

Filter source data to limit the amount of source data that enters the data flow.

When you configure a filter, you select the source field and configure the operator and value to use in the filter.

When you configure more than one filter, the task applies the filter expressions in the listed order.

You can use a parameter for a filter expression and define the filter expression in the task.

You can configure an advanced filter to use an input parameter for one of the fields, to be selected when the task runs. You can reuse the same parameter in an Expression transformation to create a field expression and in the Target transformation.

Sort

For some connector types, you can sort source data to provide sorted data to the mapping. For example, you can improve task performance when you provide sorted data to an Aggregator transformation that uses sorted data.

You can sort data in ascending or descending order.

When you sort data, you select one or more source fields and the sort order that you want to use. When you select more than one source field, the task sorts the fields in the listed order.

You can use a parameter for sort order and define the sort field and sort order in the task.