Use the Transform to Logical Data Model wizard to transform
a physical data model into a logical data model.
Before you begin
Before transforming a physical data model, check the model
validity and property settings:
Procedure
To transform a physical data model into a logical data
model:
- Select a physical data model or a physical data model object
in the Data Project Explorer. You can transform from a
.pdm file, a database, a schema, or a table.
- Click from the main
menu. As an alternative, you can click the Transform
to Logical 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 physical data model, clear
the Analyze physical model before transformation check
box.
- If you want to analyze the physical data model, perform the
following steps:
- Ensure that the Analyze physical model before transformation check
box is selected and click Next.
- Review the physical 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 Logical Model page of the wizard, specify
whether to create a new logical data model or update an existing logical
data model.
Tip: The traceability option creates
a dependency between physical data model objects and logical 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 logical data model, you also can use
traceability to match certain types of data model objects that are
renamed during transformation.
- Complete the remaining steps of the wizard.
Results
If you selected to create a new logical data model, the logical
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 logical 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.