Setting Datatypes for Lookup Columns

Ensure that lookup columns for a generated physical data model have the correct datatype.

When you generate a physical data model (PDM) from a RAP Messages logical data model that has lookup information defined, the lookup column in the generated PDM may not have the datatype defined after the transformation is done. This typically occurs in a new RAPCache or RAPStore model, where the lookup column has a foreign key to a non-market data table, such as the Instrument table in the sample model.

To set missing datatypes for lookup columns, you must regenerate (repeat the transformation), or manually set the datatype.

  1. Before transformation, try opening the PDM that has the RAPCache extension.
  2. After transformation, check that lookup columns have a datatype assigned.
  3. If datatypes are missing, regenerate the PDM.
  4. If the issue persists, manually set the datatype for such columns.
Parent topic: Generating a RAPCache or RAPStore Model from a RAP Messages Model
Related tasks
Generating a RAPCache or RAPStore Model from a RAP Messages Model
Checking Indexes
Setting Physical Options
Adding Foreign Keys