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.