Examining a Soundex - trillium_discovery - trillium_quality - Latest

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:02:04.502478

When examining soundexes, you can choose to go through every soundex listed for an attribute or only those soundexes that look suspicious.

You may find that you first need to examine entity rows and understand the context of a value before you can determine whether a value is correct or not.

Note: Soundexes are not available for numeric values and non-ASCII encoded data.

Examine soundexes

To examine soundexes

  1. In the Navigation View, click the Discover bar, then click the Entities tab.
  2. Expand the entity with which you want to work.
  3. Click the attribute with which you want to work.

    The Summary Data View for the selected attribute opens.

  4. Click the Content Summary tab and click Soundexes Distribution.

    The Top 5 Soundexes pie chart displays, showing the 5 soundexes that occur the most in the attribute, and a section that represents the total percentage of all other soundexes found, if any. (If no chart displays, the attribute has no soundexes.)

  5. Click Validity, and note the Soundex Count. (If you do not see this metadata, the attribute has no soundexes.)
  6. Click Soundex Count.

    The Soundexes List View opens. (You can also click in the Top 5 Soundexes pie chart to open this List View.)

  7. Examine theSoundexes List View.

List Soundex Values

To list soundex values

  1. In the Soundex List View, select one or more soundex rows.
  2. Right-click the selection and select Drill down to matching values.

    The Values List View opens.

  3. Examine the data values that match the soundex code(s) you highlighted.

Examine Suspicious Soundexes

To examine suspicious soundexes

  1. In the Soundex List View, sort by Value Count in descending order.

    The list shows you all soundexes that have more than one value associated with it.

  2. Double-click any row that displays a soundex code you want to examine.

    The Values List View displays.

  3. Examine the values in the attribute that match the soundex code you selected.
  4. Examine the displayed values for typing errors, misspellings, or duplicates.

Examine Matching Rows

To examine matching rows

By looking at matching rows, you can discover misspellings, different name or value conventions, typing errors, and other inconsistencies in attribute values.

  1. In the Values List View for a soundex, sort by Value to group all values that have the same soundex code.
  2. Select the rows you want to investigate by highlighting them.
  3. Right-click the selection and select Drill down to matching rows.
  4. Examine the rows that match the values you selected.