About Word Definition Table - trillium_discovery - trillium_quality - 17.1

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Trillium > Trillium Quality
Version
17.1
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Topic type
Administration
Overview
How Do I
Configuration
Reference
Installation
First publish date
2008

After you analyze words and phrases in the input attribute, you can create your own table and define business categories, words and phrases to organize your data. This is called a word definition table. For example, if you have the input row "X-Large Blue Tee Shirt" in your inventory data, you can assign "X-Large" to the SIZE category, "Blue" to COLOR, "Tee" and "Shirt" to TYPE. You can further identify your data by adding recodes, synonyms, and classifications. Word definition tables created during profiling activities are stored in the Library in Discovery. You can modify and test the table in the Parser Tuner and import it for use in the Business Data Parser (BDP) process.

Guidelines

  • The maximum number of characters in an entry is 1000.
  • The maximum number of characters for each word/phrase is 500. If the word/phrase exceeds 100 characters, you must increase the size of the BDP output attributes in the Schema Editor. See Modifying Attributes.

The word definition table gives you the following options to define your data for the BDP process:

  • Categories: Categories are attribute types that help define patterns the BDP uses to standardize data. You can specify a maximum of 500 categories. When the BDP process runs, all data is placed in output attributes according to how the data is categorized and the category names will replace the default attribute names, BP_USER1 -500.
  • Position: Set the position to define the word/phrase location within the output data line.
  • Recodes: Recode words and phrases to conform and standardize the data.
  • Classifications: Add classifications to a word or phrase to enhance the definition.
  • Synonyms: Create synonyms of original data values to correct misspellings and identify words in the output.