Monday, February 18, 2019

Question :12) 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.

No comments:

Post a Comment