Use the Lookup transformation to look up data in an

Oracle Autonomous Database

object. For example, the source table includes the customer code, but you want to include the customer name in the target table to make summary data easy to read. You can use the

Oracle Autonomous Database

Lookup transformation to look up the customer name in another

Oracle Autonomous Database

object.

You can add the following lookups to a mapping:

Connected with cached
Connected with uncached
Unconnected with cached
Dynamic lookup cache

For more information about the Lookup transformation, see

Transformations

in the

Data Integration

documentation.