Using enterprise naming standards

You can select naming standards or models that you want to use for column names in the source or target elements. These standards are used when you run the discover function. Naming standards are used to ensure that the names that you use within the metadata conform to a set of rules. For example, you can define a rule that always shortens the word EMPLOYEE to EMP.
Prerequisite:

Create and open a mapping model that contains sources or a target.

You can create naming models by using the glossary model that is provided in the workbench. Naming models are files with a file type of .ndm. You can also import existing .ndm files into the data design project. When the naming models are available to the discover function, the results of the discover function are more accurate.

To associate one or more naming models with each schema in the mapping editor:

  1. Right-click in the mapping editor. You can run the discover function from any pane if a source or a target is selected.
  2. Click Discover Relationships and select Enterprise Naming Standard.
  3. Select a schema from the list of schemas and click Add. The Select Naming Model Files window opens.
  4. Select a naming model from the list of available naming models.
  5. Click OK.
The naming model that you select is always associated with a certain schema. You can associate the same naming model to different schemas. The naming model is used by the lexical similarity and semantic name algorithms when you run the discover function to find matches. The association between a naming model and a schema does not persist after the current mapping session is closed. You must select a naming model to use each time you reopen the mapping editor.
Related tasks
Creating and using naming models

Feedback