Wednesday, January 2, 2013

What is the difference between Source Qualifier Transformations Source Filter to Filter transformation?


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