Database Reference
In-Depth Information
Configuring the Lookup transformation
We have learned how to create a Lookup transformation in the previous section. Now we
will implement a mapping similar to the one shown in the Joiner transformation using the
Lookup transformation. We will use the
EMPLOYEE
Oracle table as the source and will
look up the
EMP_FILE
flat file. Perform the following steps to implement the mapping:
1. Drag the
EMPLOYEE
table as the source in Mapping Designer and drag the target.
2. We have already created the Lookup transformation.
3. To get the relevant data based on the matching conditions of the
EMPLOYEE
table
and the
EMP_FILE
file, drag the
EMPLOYEE_ID
column from the
EMPLOYEE
table to the Lookup transformation. Drag the corresponding columns from the
EMPLOYEE
source qualifier and Lookup transformation to the target, as shown in
the following screenshot:
4. Click on the
Condition
tab and create a new condition, as shown in the following
screenshot: