Previous
Next
Previous |
Next |
OWB maintains a business name and a physical name for each object stored in the repository. A business name is a descriptive logical name for an object. A physical name is the actual object name recognized by the repository.
When you generate DDL scripts for a named object, the physical names are used. Physical names must conform to the syntax rules for basic elements as defined in the Oracle Database SQL Language Reference.
Names must be unique within their category:
Module names must be unique within a project.
Warehouse object names must be unique within a warehouse module. This includes the names of tables, dimensions, cubes, mappings, materialized views, sequences, views and indexes.
Transformation names must be unique within a transformation package.
Business Name Mode Use Business Name mode to create a business name for an object or to change the business name of an existing object. When this mode is selected, OWB editors, wizards, and property sheets display the business names of objects.
A business name must conform to these rules:
The name must be unique within its category.
All source modules reflect the case of the imported source and are subject to the double-quotes rules as defined in the Oracle Database SQL Language Reference.
Copy operations from a source to a target in a mapping are not case-sensitive.
When you create a business name, OWB generates a corresponding, valid physical name that resembles the business name. If you create a business name that duplicates an existing physical name, then OWB appends an underscore and a number in order to create a unique name.
Physical Name Mode Use Physical Name mode to create a physical name for an object or to change the physical name of an existing object. When this mode is selected, OWB editors, wizards, and property sheets display the physical names of objects. Physical names are converted to UPPERCASE.
An object's physical name must conform to these rules:
Contain no more than 30 characters.
Conform with the basic syntax rules for schema objects as defined by Oracle Database SQL Language Reference.
|
Note: A collection can have a physical name containing up to 200 characters. |
OWB prevents you from entering an invalid physical name. For example, you cannot enter a duplicate name, a name with too many characters, nor a name that is a reserved word.
Setting the Name Mode To create or change a business name for an object, OWB must be in Business Name mode. To create or change a physical name for an object, OWB must be in Physical Name mode.
The default naming preferences for OWB are as follows:
Mode: The default setting for the mode is physical name mode.
Propagation: The default propagation setting is to propagate physical name to business name.
Icons for the name mode and name propagation settings are located in the lower-left corner of the editors. These icons indicate the current naming preference setting.
OWB saves your naming preferences across sessions. The Name Mode preference is stored in a file on the client workstation. If you use OWB from another workstation, your preferences may be different.