A lookup table defines the value range of fields that are defined by a field standard. For example, the lookup table that is referenced by a field standard named gender contains male and female. This topic describes how to create a lookup table.
Create a directory
Go to the Data Modeling page.
Log on to the DataWorks console. In the left-side navigation pane, choose . On the page that appears, select the desired workspace from the drop-down list and click Go to Data Modeling.
Go to the Lookup Table page.
In the top navigation bar of the Data Modeling page, click Data Standard.
In the left-side navigation pane of the page that appears, click Lookup Table.
Create a directory.
In the Lookup Table pane, click the
icon and select Create Directory. In the Create Directory dialog box, enter a name in the Name field and click OK.
After the directory is created, you can view the directory in the Lookup Table pane.
Create a lookup table
In the Lookup Table pane, find the created directory, right-click the directory name, and then select Create Lookup Table.
In the Create Lookup Table dialog box, configure the parameters and specify enumeration values.
Configure the parameters
Parameter
Description
ID
The ID of the lookup table.
Display Name
The display name of the lookup table.
Name
The name of the lookup table.
Description
The description of the lookup table.
Specify enumeration values
Click Add in the Create Lookup Table dialog box and configure the parameters.
NoteTo specify multiple enumeration values, click Add and configure the parameters multiple times.
To delete an enumeration value, find the value and click Delete in the Actions column.
To clear all the enumeration values that you specify or specify the enumeration values again, click Clear.
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 up to 2,048 characters in length.
Delete a lookup table
To delete a lookup table, find the table in the left-side navigation tree, right-click the table name, and then select Delete.
If the lookup table that you want to delete is referenced by a field standard, you must remove the reference relationship between the lookup table and the field standard first.
What to do next
When you configure fields for fact tables and dimension tables, you can associate fields with the created field standard. For more information, see Publish and manage a table.