Naming conventions for mappings
Auto-generated mappings have default names that must meet constraints for uniqueness and maximum length. If you customize automatically-generated names, the customized names must still comply with these constraints.
- Uniqueness—Default mappings include an algorithm to provide uniqueness. Uniqueness is required only within a certain scope; for example column name within a view, view name within a Reporting and Analysis database.
The uniqueness algorithm adds a numeric suffix to items that have the same name.
Note: The resulting name may be subject to the max length limitation.
- Max length—The Oracle database has a thirty character limitation for any name. If the auto-generated Oracle database name (view or column) exceeds 30 characters, it is shortened according to the following algorithm:
- Remove all characters after the 26th character.
- Append an underscore (_), and if this is the first iteration, add '1', otherwise increment it.
- Test for uniqueness. If the column or view name exceeds 30 characters as a result of adding a suffix to resolve uniqueness, the algorithm is applied.