You can use an Filter transformation in a dynamic mapping. You can configure dynamic ports in the transformation and reference the generated ports in the filter condition.
You can parameterize the complete filter condition. Configure an expression parameter with a default value that contains the entire expression. The Developer tool does not validate a filter condition in a parameter default value.
You can reference a dynamic port in a filter condition. The dynamic port can contain multiple generated ports. The Data Integration Service expands the filter condition to contain each generated port. Each generated port must be a valid type to include in the expression.
You can reference a generated port in a filter condition. However, if the generated port does not exist at run time, the mapping fails.