The Lookup object allows a data pump consumer to specify one or more named, parameterized query strings that allow a custom transformation to retrieve data from locations other than the immediate source or destination row being transformed. For example, a Lookup object might reference data in a Microsoft® Excel workbook.
| ConnectionID Property | Parent Property |
| MaxCacheRows Property | Query Property |
| Name Property |