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.
0 comments :
Post a Comment