Filter transformation

Filter transformation is an active and connected transformation.

Using the Filter transformation, we can filter rows in a mapping. We pass all the rows from a source transformation through the Filter transformation, and then enter a filter condition for the transformation. All ports in a Filter transformation are input/output and only rows that meet the condition pass through the Filter transformation.

Working with the Filter Transformation...

• Import Source and Target.
• Then create Filter transformation.
• Edit Filter Transformation. Go to Properties Tab
• Click the Value section of the Filter condition, and then click the Open button.
• The Expression Editor appears.
• Enter the filter condition you want to apply.
• Click Validate to check the syntax of the conditions you entered.

Tip: Using the Filter transformation at the source side for the best performence because only the filter rows pass to the next level of transformation.