Use the Properties view to set the transformation properties of
relationship objects before you transform a logical data model into a physical
data model.
Prerequisite: Before you modify the properties of logical data
model objects, you must open a logical data model in the logical data model
editor.
To set relationship transformation properties for logical-to-physical
data model transformation:
- Select a relationship object in the Data Project Explorer, or in
a diagram.
- Click to open the
Properties view, if the view is not already open.
- Optional: On the General tab in the
Properties view, modify the Transform as property by
selecting one of the following options:
Option |
Description |
Separate table |
Select to specify that entities
in the relationship are transformed to separate tables. This option is the
default option. |
Merge |
Select to specify that entities in
the relationship are transformed into one merged table. |
- Save the logical data model.