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.
Before you begin
Prerequisite:Create and open a mapping model that contains
sources or a target.
About this task
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:
- Right-click in the mapping editor. You can run the discover function
from any pane if a source or a target is selected.
- Click and select Enterprise Naming Standard.
- Select a schema from the list of schemas and click Add.
The Select Naming Model Files window opens.
- Select a naming model from the list of available naming models.
- Click OK.
Results
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.