To access XLATTABLE data through a Lookup transformation, define the lookup condition. Before defining the lookup condition, create an input port for the data you want to pass to the Lookup transformation. This input port contains the codes you want to describe. Use this port in the lookup condition. The PowerCenter Integration Service compares this data with corresponding data in the XLATTABLE table.

The lookup condition sets the FIELDVALUE port of the XLATTABLE table equal to the input port you create:

For example, you create a mapping that looks up the XLATSHORTNAME value from the XLATTABLE table to define customer status codes. The Lookup transformation contains an input port, CUST_STATUS_IN, to accept customer status codes from the Source Qualifier. These codes include A and I.

The following table shows the rows that can be defined in the XLATTABLE table:

The following lookup condition in LKP_XLATTABLE Lookup transformation looks up the customer status definitions in the XLATTABLE table:

The Lookup Table Column value is FIELDVALUE. The Transformation Port value CUST_STATUS_IN contains customer status codes.