How to join two tables without using the Joiner Transformation.

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

  Was this answer useful?  Yes

sithusithu

  • Jan 19th, 2006
 

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

  Was this answer useful?  Yes

subrahmanya Rajesh

  • 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 .

  Was this answer useful?  Yes

ravi kumar guturi

  • Mar 10th, 2006
 

simple,

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

  Was this answer useful?  Yes

Ray Anthony

  • 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

  Was this answer useful?  Yes

prasadns26

  • Jul 18th, 2006
 

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.

  Was this answer useful?  Yes

vikota

  • Apr 12th, 2011
 

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

  Was this answer useful?  Yes

Give your answer:

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

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions