✍ Kashif M
Trends

Friday, 2 October 2015


Source Qualifier Transformations Filter Vs Filter Transformation


By on October 02, 2015

Source Qualifier Transformations Filter Vs Filter Transformation
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


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.

Kashif
mkashu: Source Qualifier Transformations Filter Vs Filter Transformation
Review : Kashif | Kashif
Update: October 02, 2015 | Rating: 4.5

Comment for "Source Qualifier Transformations Filter Vs Filter Transformation"

0 comments

Post a Comment