Derive a Model › Apply Naming Standards to the Derived Model

Apply Naming Standards to the Derived Model

Use the features in the Naming Standards pane to apply naming standards to the derived model. Only certain derive scenarios (such as deriving a physical model from a logical model) use name mapping. When the selected model types for the derive cannot use name mapping, no options appear on this pane.

To apply naming standards for the derived model

1. Click Design Layers, Derive New Model on the Actions menu.

   The Derive Model wizard opens on the Target Model pane.

2. Click Naming Standards in the Explorer pane.

   The Naming Standards pane opens.

3. Work with the following options:

   Object Type

   Displays the objects for which you can set name conversion preferences. When two objects appear in the box, you set the name conversion preferences from the first object to the second object.

   Property/Value Table

   Displays a two column table that lists the property and value for the selected object type. To change the value, click the row in the table to edit the text (for example, to change the macro) or display a drop-down list with the available options. The available options include:

   Macro Text

   Specifies the default macro that is used to derive the physical model object name from the logical model object name. You can enter a new macro for the selected object type.

   Use Glossary

   Specifies that your glossary should or should not be used in name mapping. Select true to use a glossary of words and abbreviations to derive the physical model object name. Select false to not use a glossary of words and abbreviations.

   Abbreviation Type

   Specifies that you will use an abbreviation or alternate abbreviation from the glossary to derive the physical model object name. Available only when you select true in the Use Glossary option.

   Prefix

   Specifies the prefix text to add before table, view, column, domain, relationship, index, and validation names in the physical model. You can click the row in the table, then enter the prefix name.

   Suffix

   Specifies the suffix to add after table, view, column, domain, relationship, index, and validation names in the physical model.

   Special Characters

   Specifies how to treat special characters. You can leave them unchanged, remove them, or replace them with a character you indicate.

   Remove Vowel

   Indicates that you want to remove vowels from object names in the derived model.

   Use Naming Standards

   Specifies an existing naming standards (*.nsm) file to use when enforcing standards in the derived model. Use Browse File System or Browse Mart to select a standards file.

   Click Next.

   The Options pane opens.