5 Difference Between Source Qualifier and Joiner Transformation in Informatica

When it comes to join two or more data sets, ETL developers are in dilemma whether to choose source qualifier (SQ) or joiner transformation.

I have collated a few differences between these two Informatica transformations. It will help you in deciding whether to use a source qualifier or joiner in your business requirements.

Source Qualifier Transformation vs Joiner Transformation

Let’s compare both transformations in tabular form.

#Source Qualifier (SQ) TransformationJoiner Transformation
01The performance of source qualifier transformation is better and optimized than joiner transformation. The performance of the joiner transformation is slower compared to the source qualifier transformation.
02The source qualifier transformation is used to join two or more homogeneous sources.The joiner transformation is used to join two or more homogeneous or heterogeneous sources.
03This transformation performs logical or mathematical operations like filtering, aggregator, sorting, and many more.This transformation performs only join operations like inner join (or normal join), left join, right join (master outer join or detail outer join), and full outer join.
04SQ transformation does not create a cache because the query is executed on the database directly while running the job. The joiner transformation creates the cache for the master data set while running the job. One is the ‘index cache’ and another is the ‘data cache’.
05The source qualifier transformation supports equi and non-equi join. The joiner transformation supports only equi join.

This comparison of SQ and joiner transformation covered all the basic differences. Please note that both are active types of transformation.

In this Informatica series, I have covered differences of transformation articles –

If you have any queries or points to add, please comment below.

Thanks for Reading!

Are you looking for job?

Job openings »

 

Leave a Comment