The lookup tables are loaded once during initialization, and contain the lookup data.
The lookup column must be convertible into the RDS type of the lookup data. The lookup return column data type must be convertible into the datatype of the destination column of the target table.