What r the diffrence between joiner transformation and source qualifier transformation?

Source qualifier Homogeneous source

Joiner Heterogeneous source

Cheers,

Sithu

Hi,

The Source Qualifier transformation provides an alternate way to filter rows. Rather than filtering rows from within a mapping, the Source Qualifier transformation filters rows when read from a source. The main difference is that the source qualifier limits the row set extracted from a source, while the Filter transformation limits the row set sent to a target. Since a source qualifier reduces the number of rows used throughout the mapping, it provides better performance.

However, the Source Qualifier transformation only lets you filter rows from relational sources, while the Filter transformation filters rows from any type of source. Also, note that since it runs in the database, you must make sure that the filter condition in the Source Qualifier transformation only uses standard SQL.

Shivaji Thaneru

  1 User has rated as useful.

  

Login to rate this answer.

hi, as per my knowledge, you need matching keys to join two relational sources both in Source qualifier as well as in Joiner transformation. But the difference is that in Source qualifier, both the keys must have primary key - foreign key relation, Whereas in Joiner transformation its not needed.

source qualifier is used for reading the data from the database where as joiner transformation is used for joining two data tables.

source qualifier can also be used to join two tables but the condition is that both the table should be from relational database and it should have the primary key with the same data structure.
using joiner we can join data from two heterogeneous sources, like two flat files or one file from relational and one file from flat.

  1 User has rated as useful.

  

Login to rate this answer.