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

U can join hetrogenious data sources in joiner transformation which we can not achieve in source qualifier transformation.
U need matching keys to join two relational sources in source qualifier transformation.Where as u doesn’t need matching keys to join two sources.
Two relational sources should come from same datasource in sourcequalifier.U can join relatinal sources which r coming from diffrent sources also.

  • Interview Candidate
  • 6
  • 18834

Showing Answers 1 - 6 of 6 Answers

Shivat

  • Sep 13th, 2006
 

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

pkonakalla

  • May 23rd, 2007
 

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.

  Was this answer useful?  Yes

divakar

  • Nov 5th, 2007
 

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.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions