Transform to Physical Data Model wizard - Options page

Use this page to specify options for the transformation.
Physical Name
Specify options for transforming object names.
Use upper case
Select to specify that physical data model object names are created using all uppercase characters. For example: TABLENAME1
Use lower case
Select to specify that physical data model object names are created using all lowercase characters. For example: tablename1
Use title case
Select to specify that physical data model object names are created using title case. For example: Tablename1
Use name
Select to specify that physical data model object names are created based on the name of the source logical data model object.
Use label
Select to specify that physical data model object names are created based on the label of the source logical data model object. If you select this option and there are data objects in the logical data model without labels, names are used instead.
Data type defaults
Specify options for the default data type.
Data type
Specify a default physical data type. The default data type is used as the physical data type if the logical data type is not defined for an attribute or if an attribute has an invalid logical data type.
Length
Specify a default length value. The default length is used when an attribute has a logical data type for which a required length was not specified.
Precision
Specify a default precision value. The default precision is used when a attribute has a logical data type for which a required precision was not specified.
Scale
Specify a default scale value. The default scale is used when a attribute has a logical data type for which a required scale was not specified.
Surrogate key
Specify options for transforming surrogate keys. These options might not be available if the target database vendor and version does not support identity columns or sequences.
Generate identity column
Select to specify that surrogate keys are transformed to identity columns.
Generate sequence
Select to specify that surrogate keys are transformed to sequences.
Miscellaneous
Specify additional options for the transformation.
Copy
Select elements from the logical data model that you want to copy to their physical model element equivalents.
Transform diagrams
Select to generate physical data model diagrams that correspond to all logical data model diagrams. If you do not select this option, you can generate diagrams after you complete the wizard.
Generate traceability
Select this option to generate traceability between attributes in the logical data model and the resulting columns in the physical data model. Traceability is maintained through dependencies between the attributes and the columns that have a dependency type of TRANSFORM_TRACEABILITY. These dependencies are owned by the columns in the physical data model. If you generate traceability, you can discover these dependencies by performing an analyze impact action on the column or attribute.
Column ordering
Specify whether to place all key columns first in generated tables.
Schema name
Type a name for the physical data model schema. If you are transforming to an existing model or using a template model, you can browse to a target schema in the target model. Generated physical data model elements are contained in the target schema, and relationships are resolved to existing elements in the target schema. If you do not specify a target schema, the default (root) target schema is used.
Join table separator
Type a separator for join table names. A join table is the physical equivalent of a many-to-many logical relationship. Join table names are composed of the names of the two tables that participate in the relationship separated by a separator character. For example: Employee_x_Department.
Roll up type table suffix
Type a suffix for type table names. This string is used to create type table names when the Transform as property of a logical model generalization object is set to Roll Up.

Feedback