Question

What are the differences between joiner transformation and source qualifier transformation?

Answer 1

Source Qualifier Operates only with relational sources within the same schema. Joiner can have either heterogenous sources or relation sources in different schema 2. Source qualifier requires atleats one matching column to perform a join. Joiner joins based on matching port. 3. Additionally, Joiner requires two separate input pipelines and should not have an update strategy or Sequence generator (this is no longer true from Infa 7.2). 

1)Joiner can join relational sources which come from different sources whereas in source qualifier the relational sources should come from the same data source. 2)We need matching keys to join two relational sources in source qualifier transformation.Where as we doesn?t need matching keys to join two sources.

Answer 2

Explanation:

1)Joiner can join relational sources which come from different sources whereas in source qualifier the relational sources should come from the same data source. 2)We need matching keys to join two relational sources in source qualifier transformation. Where as we doesn?t need matching keys to join two sources.