- In Designer, switch to Mapping Designer and open the map.
Select filter conversion, and then enter a new conversion name. The naming convention for filter conversions is fil_transformationname. Click Create, and then click Finish.
- Select and drag all required ports from the source qualifier or other transformations to add them to the filter transform.
When you select and drag a port, a copy of these ports appears in the filter transformation. Each column has both an input and an output port.
- Double-click the new converted title bar.
- Click the Properties tab.
The default condition appears in the list of conditions. The default condition is TRUE (a constant with a numeric value of 1).
- Click the value section of the condition, and then click the Open button.
The expression editor appears.
- Enter the filter criteria you want to apply.
Use one of the input port values in the transformation as part of this condition. However, you can also use the output port values from other transformations.
- Click Validate to check the conditional syntax that you entered.
You may have to fix a syntax error before proceeding.
- Select the desired tracking level, and click OK to return to the Mapping Designer.
- Select Library-Save to save the mappings.
Informatica Common components filter creation fil