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
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.
Procedure
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.