Use the Transform to Physical Data Model wizard to transform
a logical data model into a physical data model.
Before you begin
Before transforming a logical data model, check the model
validity and property settings:
Procedure
To transform a logical data model into a physical data
model:
- Select a logical data model or a logical data model object
in the Data Project Explorer. You can transform from an
.ldm file, a package, or an entity.
- Click from the
main menu. As an alternative, you can click the Transform
to Physical Data Model toolbar button
on the main
toolbar.
- If the Check Model page is displayed, select the appropriate
options:
- If you do not want to analyze the logical data model, clear
the Analyze logical model before transformation check
box.
- If you want to analyze the logical data model, perform the
following steps:
- Ensure that th the Analyze logical model before transformation check
box is selected and click Next.
- Review the logical data model analysis results on the Check Model
Results page.
- If problems are found in the model and you want to fix them, click Cancel to
close the wizard. The details of the model analysis problems are shown
in the Problems view. Double-clicking an entry in the Problems view
selects the appropriate model elements in the Data Project Explorer.
- On the Target Physical Model page of the wizard, specify
whether to create a new physical data model or update an existing
physical data model. If you select to create a new physical
data model, you can select a template to use on the next pages of
the wizard. You can use a provided template or you can use a template
that was exported from an existing physical data model. The resulting
physical data model is a copy of the template with the addition of
elements that are generated by the transformation.
The Generate
traceability option specifies that you want to create
a dependency between logical data model objects and physical data
model objects so that you can trace the lineage of the objects. This
dependency, when used with the impact analysis feature, helps you
to determine what objects are impacted by changes to other objects.
If you are updating an existing physical data model, you also can
use traceability to match certain types of data model objects that
are renamed during transformation.
The Transform
diagrams option specifies that you want to generate the
diagrams that exist in the logical model to include those diagrams
in the physical data model. If you are creating a new physical data
model, the diagrams will be generated when the transformation wizard
completes. All of the objects in the diagram will be transformed.
If you are updating an existing physical data model, the diagrams
will be generated when the Compare editor is closed. All of the entities
in diagram will be transformed into the corresponding existing or
new objects in the physical data model.
- Complete the remaining steps of the wizard.
Results
If you selected to create a new physical data model, the physical
data model is created and displayed in the
Data Models folder
of the data design project that you specified.
If you selected to
update an existing physical data model, the compare editor opens so
that you can merge changes. If you are using traceability, all renamed
table, column, entity, and attribute pairs are resolved automatically.
To use traceability, the Use transformation traceability
in determining renamed tables, columns, entities, and attributes check
box must be selected on the Data Object Compare preference page, and
the traceability option must be used consistently during transformations.
If
errors occur during the transformation, they are logged as entries
in the Error Log view. A stack trace is attached to an error log entry,
if applicable. To see the details of an error log entry, including
its stack trace, double-click the entry.