Translate topic in your language

Showing posts with label Lookups. Show all posts
Showing posts with label Lookups. Show all posts

Monday, 18 February 2019

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.