Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

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




673
views
asked marvit September 20, 2014 08:04 AM  

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


           

1 Answers



 
answered By Mswami   0  
Source Qualifier Operates only with relational sources within the same schema.

Joiner can have either heterogeneous sources or relation sources in different schema

Source qualifier requires atleast one matching column to perform a join. Joiner joins based on matching port.

Additionally, Joiner requires two separate input pipelines and should not have an update strategy or Sequence generator (this is no longer true from Informatica 7.2).

Joiner can join relational sources which come from different sources whereas in source qualifier the relational sources should come from the same data source.

We need matching keys to join two relational sources in source qualifier transformation.Where as we doesnt need matching keys to join two sources.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert