You can create a Filter transformation in the Transformation Developer or the Mapping Designer. A Filter transformation contains the following tabs:
Enter the name and description of the transformation. The naming convention for a Filter transformation is FIL_
. You can also make the transformation reusable.
Create and configure ports.
Configure the filter condition to filter rows. Use the Expression Editor to enter the filter condition. You can also configure the tracing level to determine the amount of transaction detail reported in the session log file.
Create a non-reusable metadata extension to extend the metadata of the transformation transformation. Configure the extension name, datatype, precision, and value. You can also promote a metadata extension to be reusable if you want to make it available to all transformations.