Configuring Lookup Tables

When you create a lookup table, you must specify at least two columns—one containing the unique identifier for each row in the table and one or more columns containing translation values.
  1. In the left pane of Marketing Warehouse Administration, click Web Analysis > Visitor Data Mart > Lookup Tables.
  2. Click New. The New Lookup Table wizard opens.
  3. In the Lookup Table Name text box, specify a lookup table name.
  4. Click New.
  5. In the Column Name text box, specify a column name.
  6. Select an attribute type from the Attribute Type list. If you select Date, select a format from the list.

    The Numeric field accepts up to 12 characters with up to 4 decimal places. The Alphanumeric – Large field accepts up to 900 characters. As you create attributes, the number of attributes created and the number of each type allowed are displayed to the right of the Attribute Type text box.

  7. Repeat Steps 2 through 6 as necessary.
  8. If you create a lookup table with multiple columns, indicate which column contains the unique identifier for the lookup table.
  9. Click Next.
  10. If you are satisfied with the new lookup table, click Save.