Use this page to specify options for the transformation.
- Physical Name
- Specify options for transforming object names.
- Use upper case
- Select to specify that logical data model object names are created using
all uppercase characters. For example: TABLENAME1
- Use lower case
- Select to specify that logical data model object names are created using
all lowercase characters. For example: tablename1
- Use title case
- Select to specify that logical data model object names are created using
title case. For example: Tablename1
- Use name
- Select to specify that logical data model object names are created based
on the name of the source physical data model object.
- Use label
- Select to specify that logical data model object names are created based
on the label of the source physical data model object. If you select this
option and there are data objects in the physical data model without labels,
names are used instead.
- Data type defaults
- Specify options for the default data type.
- Data type
- Specify a default logical data type. The default data type is used as
the logical data type if the physical data type is not defined for a column
or if a column has an invalid physical data type.
- Length
- Specify a default length value. The default length is used when a column
has a physical data type for which a required length was not specified.
- Precision
- Specify a default precision value. The default precision is used when
a column has a physical data type for which a required precision was not specified.
- Scale
- Specify a default scale value. The default scale is used when a column
has a physical data type for which a required scale was not specified.
- Miscellaneous
- Specify additional options for the transformation.
- Copy
- Select elements from the physical data model that you want to copy to
their logical model element equivalents.
- Generate traceability
- Select this option to generate traceability between columns in the physical
data model and the resulting attributes in the logical 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.
- Package name
- Type a name for the logical data model package. If you are transforming
to an existing model or using a template model, you can browse to a target
package in the target model. Generated logical data model elements are contained
in the target package, and relationships are resolved to existing
elements in the target package. If you do not specify a target package, the
default (root) target package is used.