CODEWITHSUNDEEP
lookupinformaticainformatica-powercenter
prabu R
prabu R

Reputation: 2209

Default join type in lookup transformation?

What is the default join type in the look up tranformation in informatica?

Whether it is inner join or left outer join? please clarify.

Upvotes: 0

Views: 12913

Answers (5)

VRVigneshwara
VRVigneshwara

Reputation: 1067

inner equijoin is the deafult join

Upvotes: 0

Spider
Spider

Reputation: 387

The default join type of lookup transformation is left-outer join in informatica..considering your source is the left table..

Upvotes: 0

Lev
Lev

Reputation: 41

In addition to other answers: If you using some older versions of informatica Power Center (I think lower than 9.1), there is no multiple match feature to lookup, so unlike outer join, only one single value will be returned (or NULL when no match).

Upvotes: 0

Nav
Nav

Reputation: 1394

It's Rigth outer join, every row from expression is passed forward whether a match is found or not(i.e Matching columns from lookup or NULL for Lookup columns).

Upvotes: 0

Marek Grzenkowicz
Marek Grzenkowicz

Reputation: 17353

It's an outer join - if no matching row is found in the lookup table, you get an empty one back.

Upvotes: 1

Related Questions