pal

• Feb 20th, 2007

 

A joiner is used to join data from different sources and a lookup is used to get a related values from another table or check for updates etc in the target table.

for lookup to work the table may not exist in the mapping but for a joiner to work, the table has to exist in the mapping.

pal.

Noel Lastra

 Profile 

• Feb 22nd, 2007

 

a lookup may be unconnected while a joiner may not

vizaik

 Profile Answers by vizaik 

• Mar 24th, 2007

 

lookup may not participate in mapping
lookup does only non equi join


joiner table must paraticipate in mapping
joiner does only outer join

Nishikant Shekhar

 Profile Answers by Nishikant Shekhar 

• Jul 22nd, 2009

 

Lookup transformation is a Passive transformation where as Joiner is Active Transformation.

Lookup you can have both connected as well as unconected where as Joiner is always connected.

Joiner is used to join two homogenious or hetrogenious sources residing at different location where as lookup is used to look-up the data.

Lookup is by default left outer join where as joiner You can have Normal, Master Outer, Detail Outer, Full Outer.

pr

• Mar 10th, 2016

 

Joiner :
> It support equiv Join only.
> It may be we can perform outer join only.
> Joiner is used to source only.
> It may be only "=" operator used.
> In joiner may be not present in lookup override.
Lookup :
> It supports Equiv and non equiv join.
> Lookup used to source as well as target.
> It can not perform outer join in lookup.
> It may be = , < , > , <= . >= are used.
> It may be present in lookup override option.