When using a Lookup transformation to access XLATTABLE data, configure the Location Information property on the Properties tab of the Lookup transformation. The PowerCenter Integration Service uses information in the Location Information property to locate the XLATTABLE table.

By default, the Location Information value is $Source for the XLATTABLE table, since you import it from a source database. When you accept the default, the PowerCenter Integration Service uses the session source application connection to locate the XLATTABLE table. You can select a database connection to replace the default location.

The database connection the PowerCenter Integration Service uses to access the XLATTABLE table must have the same database username, password, and connect string as the ODBC data source used to import the table.

If the session database connection does not fit this criteria, select a database connection for the Lookup transformation in the Lookup transformation or in the session properties.