top button
Flag Notify
Site Registration

Default join type in lookup transformation?

+2 votes

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

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

posted Dec 23, 2014 by Sachin

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

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).

answer Dec 29, 2014 by Shweta Singh