Setting relationship transformation properties for logical-to-physical data model transformation

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:

  1. Select a relationship object in the Data Project Explorer, or in a diagram.
  2. Click Window > Show View > Properties to open the Properties view, if the view is not already open.
  3. 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.
  4. 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.

  5. Save the logical data model.

Feedback