What is the difference between Source Qualifier Transformations Source Filter to Filter transformation?
SQ Source Filter
|
Filter Transformation
|
Source
Qualifier transformation filters rows when read from a source.
|
Filter
transformation filters rows from within a mapping
|
Source
Qualifier transformation can only filter rows from Relational Sources.
|
Filter
transformation filters rows coming from any type of source system in the
mapping level.
|
Source
Qualifier limits the row set extracted from a source.
|
Filter
transformation limits the row set sent to a target.
|
Source
Qualifier reduces the number of rows used throughout the mapping and hence it
provides better performance.
|
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.
|
The filter
condition in the Source Qualifier transformation only uses standard SQL as it
runs in the database.
|
Filter
Transformation can define a condition using any statement or transformation
function that returns either a TRUE or FALSE value.
|
No comments:
Post a Comment
Thank you :
- kareem