Question

Differentiate between Source Qualifier and Filter Transformation?

Answer 1

Differentiate between Source Qualifier and Filter Transformation?

Source Qualifier vs Filter Transformation

Source Qualifier Transformation	Filter Transformation
1. It filters rows while reading the data from a source.	1. It filters rows from within a mapped data.
2. Can filter rows only from relational sources.	2. Can filter rows from any type of source system.
3. It limits the row sets extracted from a  source.	3. It limits the row set sent to a target.
4. It enhances performance by minimizing the number of rows used in mapping.	4. It is added close to the source to filter out the unwanted data early and maximize performance.
5. In this, filter condition uses the standard SQL to execute in the database.	5. It defines a condition using any statement or transformation function to get either TRUE or FALSE.