Question: what is the difference between lookup and joiner transformation?
Answer: Difference between Lookup and joiner transformation in Informatica. ... Matching condition can be specified in the lookup transformation. The result returned can be multiple columns or single column. b) Lookup transformation can be unconnected or connected transformation.