1. Select a project or folder in the Object Explorer view.
2. Click File > New > Transformation.
3. Browse to the Lookup wizard.
4. Select Flat File Data Object Lookup, Logical Data Object Lookup, Reference Table Lookup, or Relational Data Object Lookup.
5. Click Next.
The New Lookup Transformation dialog box appears.
6. Select a physical data object or reference table in the Developer tool.
7. Enter a name for the transformation.
8. For On multiple matches, determine which rows that the Lookup transformation returns when it finds multiple rows that match the lookup condition.
9. Click Finish.
The Lookup transformation appears in the editor.
10. In the Ports section of the Overview view, add output ports to the transformation.
The following figure shows the CUSTOMER_NO output port in a Lookup transformation:
11. On the Run-time tab of the Properties view, select Lookup Caching Enabled to enable lookup caching.
Note: You must add the Lookup transformation to a mapping before you can configure run-time lookup properties.
12. On the Lookup tab of the Properties view, add one or more lookup conditions.
13. On the Advanced tab of the Properties view, configure the tracing level, dynamic lookup cache properties, and run-time connection.
14. Save the transformation.