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

Use the Properties view to set the transformation properties of attribute 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 attribute transformation properties for logical to physical data model transformation:

  1. Select an attribute 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. On the General page in the Properties view, modify the Persistent property as needed.

    If you select Persistent, the attribute is transformed to a column. If you do not select Persistent, the attribute is not transformed. The icon for the attribute in the Data Project Explorer or in data diagrams is changed to visually indicate when it is not persistent.

    Restriction: If the attribute is part of a primary key, an alternate key, or an inversion entry that is set to be transformed to an index, you cannot modify the persistence property. These attributes are always transformed.
  4. Save the logical data model.

Feedback