Explain Lookup component in ODI 12c and what is the difference between Lookup and Join components ?

Answer:-

What is Lookup Component ?

A Lookup is a
selector component that returns data from a lookup flow being given a value
from a driving flow.The attributes of both flows are combined, similarly to a
join component.

Lookups can be
located in a dataset or directly in a mapping as a flow component.

When used in a
dataset, a Lookup is connected to two datastores or reusable mappings combining
the data of the datastores using the selected join type.

Lookups used as flow
components (that is, not in a dataset) can join two flows. A lookup condition
can be created by dragging an attribute from the driving flow and then the
lookup flow onto the lookup component.