thiyagarajanc

 Profile Answers by thiyagarajanc Questions by thiyagarajanc

• Dec 1st, 2005

 

           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

sithusithu

 Profile Answers by 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

sithusithu

 Profile Answers by sithusithu 

• Jan 19th, 2006

 

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

Cheers,

Sithu

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 .

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

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

prasadns26

 Profile Answers by 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.

vikota

 Profile Answers by 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

ram_infa

 Profile Answers by ram_infa Questions by ram_infa

• Sep 14th, 2011

 

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.