Lookup Object
The Lookup object allows a data pump consumer, for example a DataDrivenQueryTask2, DataPumpTask2 or ParallelDataPumpTask object, to specify one or more named, parameterized query strings that allow a transformation to retrieve data from locations other than the row being transformed. For example, a Lookup object might reference data in a Microsoft® Excel worksheet.
