krishnasri424

 Profile Answers by krishnasri424 

• Nov 2nd, 2006

 

Lookup can be used instead of joiner when the data is coming for same source database platform.

Joiner can be used when data is coming from hetrogeneous databases.

akmohanty

 Profile Answers by akmohanty Questions by akmohanty

• Feb 13th, 2007

 

only we can use the joiner transformation when we are retrieving the data from same source database.But we are using the joiner transformation when we are retrieving data from multiple or hetorogeneous databases.

sai

• Feb 14th, 2007

 

joiner is used to join the data from hetrogenious database plotforms or from the same plotform.lookup is used to join the data from relational database .if u want to join the all columns data from different tables having a common column from hetrogenious database plotforms or from the same plotform joiner is preferable.if u want to join the data in perticular columns from relational database it is preferible to use lookup transf, it will improve the session performance .

guy.sridhar

 Profile Answers by guy.sridhar Questions by guy.sridhar

• Oct 15th, 2007

 

The exact difference is, by using joiner we can get both matching and unmatching records from the table .

By using look up we can find out whether the records exists or not.

and other thing we can use logical operators such as >,<,<= in look up.

we cant use logical operators other than '=' in joiner...

sai kiran

• Oct 20th, 2007

 

If possible using Lookup will give better performance over joiner.

Using lookup we can perform outer joins, equi, and non equi joins.
Using joiner we can perform only equi joins.

In lookup we can also write SQL ovverrides.