The Filter transformation allows rows that meet the specified filter condition to pass through. It drops rows that do not meet the condition. You can filter data based on one or more conditions.

The following image shows a filter condition in a Filter transformation:

A filter condition returns TRUE or FALSE for each row that the Data Integration Service evaluates, based on whether a row meets the specified condition. For each row that returns TRUE, the Data Integration Services pass through the transformation. For each row that returns FALSE, the Data Integration Service drops and writes a message to the log.

You cannot concatenate ports from more than one transformation into the Filter transformation. The input ports for the filter must come from a single transformation.