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.
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:

  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.
    Merge Select to specify that entities in the relationship are transformed into one merged table.
  4. Save the logical data model.

Feedback