Setting alternate key transformation properties for logical-to-physical data model transformation

Use the Properties view to set the transformation properties of alternate key 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.

About this task

You can set general properties for an alternate key object before you transform a logical data model. You should specify whether you want to create unique indexes or unique constraints from an alternate key object.

Procedure

To set alternate key transformation properties for logical-to-physical data model transformation:

  1. Select an alternate key 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 Transform as property.
  4. If you do not want the alternate key to be transformed, make sure the Persistent box is checked.
  5. Save the logical data model.

Feedback