1. In a mapping or mapplet, drag a Lookup transformation from the Transformation pallette to the editor.
The New dialog box appears.
2. Select Flat File Data Object Lookup, Logical Data Object Lookup, Reference Table Lookup, or Relational Data Object Lookup.
3. Click Next.
The New Lookup Transformation dialog box appears.
4. Select a physical data object or reference table in the Developer tool.
5. Enter a name for the transformation.
6. For On multiple matches, determine which rows that the Lookup transformation returns when it finds multiple rows that match the lookup condition.
7. Click Finish.
The Lookup transformation appears in the editor.
8. Select the Lookup transformation in the editor.
The toolbar appears above the transformation.
9. On the Ports tab of the Propertiesview, add output ports to the transformation.
The following figure shows the CUSTOMER_NO output port in a Lookup transformation:
10. 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.
11. On the Lookup tab of the Properties view, add one or more lookup conditions.
12. On the Advanced tab of the Properties view, configure the tracing level, dynamic lookup cache properties, and run-time connection.
13. Save the transformation.