You can configure a Lookup source filter for a relational Lookup transformation that has caching enabled. Filter source rows in a lookup to limit the number of lookups that the Integration Service performs on a lookup source table.
On the
Properties
view, select the
Query
tab.
In the
Filter
option, click
Edit
.
In the SQL Editor, select the input ports or enter any Lookup transformation port that you want to filter.
Enter a filter condition.
Do not include the keyword WHERE in the filter condition. Enclose string mapping parameters and variables in string identifiers.