A lookup table defines the value range of fields that are defined by a data standard. For example, the lookup table that is referenced by a data standard named gender contains male and female. This topic describes how to create a lookup table.

Background information

A lookup table is similar to an enumeration dimension table but is more effective than an enumeration dimension table in terms of data governance. After a lookup table is referenced by a data standard, a related monitoring rule is generated in Data Quality. After you specify a field as a data standard, the value range of the field must fall in the lookup table that is referenced by the data standard. If the value range of the field falls outside the lookup table, data governance is required.

For example, if you specify the field gender as a data standard, the value of the field is male or female. Only the values male and female can be stored. If other data is stored, data governance is required.

Create a directory

  1. Go to the Dimensional Modeling page.
  2. Go to the Lookup Table page.
    1. In the top navigation bar, click Data Standard to go to the Data Standard page.
    2. In the left-side navigation pane of the Data Standard page, click Lookup Table to go to the Lookup Table page.
  3. Create a directory.
    1. On the Lookup Table page, click the Plus sign icon and select Lookup Table.
    2. In the Create Directory dialog box, configure Name and click OK. 1
      The name can contain lowercase letters, digits, and underscores (_) and must start with a lowercase letter.
    3. After the directory is created, you can view the directory in the left-side navigation tree.

Create a lookup table

  1. Find the created directory, right-click the directory name, and then select Create Lookup Table.
  2. In the Create Lookup Table dialog box, configure the parameters and specify enumeration values.
    Lookup table
    • Configure the parameters
      Parameter Description
      ID The ID of the lookup table.

      The ID can contain lowercase letters, digits, and underscores (_) and must start with a lowercase letter. The ID can be a maximum of 128 characters in length.

      Display Name The display name of the lookup table.

      The name can contain letters, digits, underscores (_), ampersands (&), and parentheses () and must start with a letter or digit. The name can be a maximum of 2,048 characters in length.

      Name The name of the lookup table.

      The name can contain letters, digits, underscores (_), and ampersands (&) and must start with a letter or digit. The name can be a maximum of 2,048 characters in length.

      Description The description of the lookup table. The description can be a maximum of 2,048 characters in length.
    • Specify enumeration values
      Click Add in the Create Lookup Table dialog box and configure the parameters.
      Note
      • To specify multiple enumeration values, click Add and configure the parameters multiple times.
      • If you want to delete an enumeration value, find the value and click Delete in the Actions column.
      • If you want to clear all the enumeration values that you specify or specify the enumeration values again, click Clear.
      Enumeration values
      Parameter Description
      Code ID The ID of the enumeration value.
      Code Name The display name of the enumeration value.
      Name The name of the enumeration value.
      Description The description of the enumeration value. The description can be a maximum of 2,048 characters in length.

Delete a lookup table

If you want to delete a lookup table, find the table in the left-side navigation tree, right-click the table name, and then select Delete.

Note If the lookup table that you want to delete is referenced by a data standard, you must remove the reference relationship between the lookup table and the data standard first.