GeekInterview.com
Series: Subject: Topic:
Question: 982 of 1135

How to join two tables without using the Joiner Transformation.

Asked by: renukhareddy | Member Since Oct-2005 | Asked on: Nov 30th, 2005

View all questions by renukhareddy

Showing Answers 1 - 9 of 9 Answers

           Itz possible to join the two or more tables by using source qualifier.But provided the tables should have relationship.             When u drag n drop the tables u will getting the source qualifier for each table.Delete all the source qualifiers.Add a common source qualifier for all.Right click on the source qualifier u will find EDIT click on it.Click on the properties tab,u will find sql query in that u can write ur sqls

  
Login to rate this answer.
sithusithu

Answered On : Jan 19th, 2006

View all answers by sithusithu

The Joiner transformation requires two input transformations from two separate pipelines. An input transformation is any transformation connected to the input ports of the current transformation. Cheers,Sithu

  
Login to rate this answer.
sithusithu

Answered On : Jan 19th, 2006

View all answers by sithusithu

can do using source qualifer, but some limitations are there.Cheers,Sithu

  
Login to rate this answer.
subrahmanya Rajesh

Answered On : Feb 15th, 2006

Joiner transformation is used to join n (n>1) tables from same or different databases ,but source qualifier transformation is used to join only n tables from same database .

  
Login to rate this answer.
ravi kumar guturi

Answered On : Mar 10th, 2006

simple,In the session property user defined options is there ,by using this we can join with out joiner

  
Login to rate this answer.
Ray Anthony

Answered On : Mar 22nd, 2006

use Source Qualifier transformation to join tables on the SAME database.  Under its properties tab, you can specify the user-defined join. Any select statement you can run on a database.. you can do also in Source Qualifier. Note: you can only join 2 tables with Joiner Transformation but you can join two tables from different databases. Cheers,Ray Anthony

  
Login to rate this answer.
prasadns26

Answered On : Jul 18th, 2006

View all answers by prasadns26

hi,u can join 2 RDBMS sources of same database using a SQ by specifying user defined joins.u can also join two tables of same kind using a lookup.

  
Login to rate this answer.
vikota

Answered On : Apr 12th, 2011

View all answers by vikota

If both the tables are available in same database by using source qualifier we can join i.e by using customized source qualifierif the tables are available in different database by using lookup we can join i.e one is source table and other is lookup table

  
Login to rate this answer.

If both the tables are relational we can join both the tables using sql override but if one table is relational and another table is a flat then we've to use joiner transformation.

  
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.