GeekInterview.com
Series: Subject: Topic:
Question: 1099 of 1134

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.

Asked by: Interview Candidate | Asked on: Sep 21st, 2004
Showing Answers 1 - 4 of 4 Answers
sithusithu

Answered On : Jan 27th, 2006

View all answers by sithusithu

  
Login to rate this answer.
Shivat

Answered On : Sep 13th, 2006

View all answers by Shivat

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

Yes  1 User has rated as useful.
  
Login to rate this answer.
pkonakalla

Answered On : May 23rd, 2007

View all answers by pkonakalla

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.

  
Login to rate this answer.
divakar

Answered On : 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.

Yes  1 User has rated as useful.
  
Login to rate this answer.

Give your answer:

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

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.