Use the Properties view to set the transformation properties
of relationship objects before you transform a logical data model
into a physical data model.
Before you begin
Before you modify the properties of logical data model objects,
you must open a logical data model in the logical data model editor.
Procedure
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. |
Roll up |
Select to specify that child entities in the relationship
are transformed to be contained in the parent table. |
Roll down |
Select to specify that entities in the relationship are transformed
into one merged table. |
- On the General page in the Properties
view, modify the Persistent property as needed.
If you select Persistent, the relationship
is used during the transformation. If you do not select Persistent,
the relationship is not transformed. The icon for the relationship
in the Data Project Explorer is changed to visually indicate when
it is not persistent. In data diagrams, the customizable line color
for non-persistent relationships is also changed appropriately.
- Save the logical data model.