Question: what is the difference between lookup and join in odi?
Answer: Joiner is used to join two homogenious or hetrogenious sources residing at different location where as lookup is used to look-up the data. Lookup is by default left outer join where as joiner You can have Normal, Master Outer, Detail Outer, Full Outer.