What is the default join type in the look up tranformation in informatica?
Whether it is inner join or left outer join? please clarify.
What is the default join type in the look up tranformation in informatica?
Whether it is inner join or left outer join? please clarify.
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).
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).