Lookup tables overview

This page describes lookup tables and how they are used in Redpoint CDP data ingestion.

Lookup tables overview

There is a set of lookup tables that support loading data to into Redpoint CDP. They are used to validate data on ingestion to ensure that it is standardized appropriately. This standardization allows for creating a set of aggregates based on the values as well as ensuring consistency in the data.

Some of the lookup tables can be updated to support customer-specific values, while others are static and set at the product level. Subsequent topics discuss the specifics of each of the lookups.

Lookup tables: core

Lookup tables: retail

As a part of the onboarding process, the lookups that can be modified will be reviewed, and a list of desired values will be captured and loaded to the system. This is one of the first steps that needs to be done in order to ensure that data will load properly. You also need to ensure that when you generate the feed layouts from your source data that you set the data to the appropriate lookup value for proper loading.

If a record is loaded through a feed layout and it has a field in it that references a lookup table, but the value provided in the field does not match a record in the lookup table, then the record will not pass validation. It will be rejected and written to the reject file.

Custom feeds also support custom lookup tables.

Lookup tables detail

Below are the details related to each of the lookup tables. As mentioned previously, you can use more than one industry-specific data domain, such as retail and healthcare. In this case, some of your lookup tables may have values that support loading data for both of those industry specific domains.

Below are the details related to each of the lookup tables, but each of them will have the following consistent layout.

All lookup table values are case sensitive. If the casing is incorrect in the data file, the record will be rejected by validation.

Field Name	Field Description
Used in Agg Calc	Indicates if the lookup value is used in summaries/aggregates or not. If it is used, then the aggregate should be listed, or if you see “All” listed, then it is used in every aggregate.
Custom Values Allowed	This field is `YES`/`NO`, indicating if you are allowed to update the list with custom values, or if it’s a static list for the product that you cannot modify.
Reference Information Description	This field will give a list of sample values to help you understand the intent of the field.
Target DB object	This is the table within the database that holds the lookup values and descriptions.
Reference Information Data Element 1	This indicates the field name in the table for the available values and the list of values.
Reference Information Data Element 2	This indicates the field name in the table for the descriptions and the examples of descriptions that are associated with each of the values.