What is the default join type in the look up tranformation in informatica?
Whether it is inner join or left outer join? please clarify.
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).
In unconnected lookup, what are the other transformations that can be used in place of that expression transformation?
