Designate a Logical Table as a Lookup Table

A logical table must be designated as a lookup table (using the Semantic Modeler) before you can use it as a lookup table.

To designate a logical table as a lookup table, you must first import the lookup table into the physical layer and drag and drop it into the logical layer.

The order in which the columns are specified in the lookup table primary key determines the order of the corresponding arguments in the LOOKUP function.

For example, if the lookup table primary key consists of the RegionKey, CityKey, and LanguageKey columns, then the matching arguments in the LOOKUP function must be specified in the same order. You use the Semantic Modeler to change the order of primary key columns.