After you analyze words and phrases in the input attribute, you can create your own business categories, along with the word and phrase definitions, that tell the BDP process how to identify and standardize your data. Word definition tables created in profiling are stored in the Library in Discovery and can be imported for use in the BDP process.
To create a word definition table
-
In the List View of phrases for the Mortgage Description attribute, select the phrase or phrases, right-click and select Add to word definitions table. The Manage Word Definitions window opens and selected phrases are displayed in the Word/Phrase column.
-
Check New Table and enter the name Word Definition Mortgage.
-
Click Manage categories. The Manage Categories window opens. Categories are attribute types the BDP uses to standardize data. When the BDP process runs, these category names will become the output attribute names and all data is placed in the appropriate output attributes. For example, if you have a category called "TYPE," the output attribute names will be TYPE, TYPE_RECODE, and TYPE_DATA_PRESENT.
-
Click Add new category three times.
-
We want to group mortgage description data into three categories: length, type, and option. Define the categories as follows:
Name |
Type |
LENGTH |
Single |
TYPE |
Single |
OPTION |
Single |
-
Click Save to save the categories and go back to the Manage Word Definitions window.
-
Assign each word and phrase to a category and position, and enter the recode for some words. The word definition table looks like as follows:
-
Example
-
-
Click Save to save the definition to the table and close the Manage Word Definitions window. The table will be saved in the Library in Discovery.
The word definition table is created. Now you can move on to Step 3, Import a Word Definition Table.