|Source Qualifier Transformations Filter Vs Filter Transformation|
SQ Source Filter
Source Qualifier transformation filters rows when read from a source.
Source Qualifier transformation can only filter rows from relational sources.
Source Qualifier limits the row set extracted from a source.
Source Qualifier reduces the number of rows used throughout the mapping and hence it provides better performance.
The filter condition in the Source Qualifier transformation only uses standard SQL as it runs in the database.
Filter transformation filters rows from within a mapping
Filter transformation filters rows coming from any type of source system in the map-ping level.
Filter transformation limits the row set sent to a target.
To maximize session performance, include the Filter transformation as close to the sources in the mapping as possible to filter out unwanted data early in the flow of data from sources to targets.
Filter Transformation can define a condition using any statement or transformation function that returns either a TRUE or FALSE value.