Transforms › Transforms in the Model Explorer

Transforms in the Model Explorer

Each transform that you apply to model objects appears in the Model pane in the Model Explorer. By default, each transform is listed in alphabetical order under the Transforms folder.

You can right-click a transform in the Model Explorer and choose Properties to open the Modify Properties for Transform dialog for the selected Transform. You can use the Modify Transform Properties dialog to document the reason that you applied a transform, assign user-defined properties to a transform, and specify that any future changes that you make to the transformed object (such as adding attributes, columns, or relationships) are also applied to the source objects.

You can also rename or delete a transform.

You can apply the following transforms to model objects to refine a logical or physical model:

• Many-to-many Transform

  Resolves a many-to-many relationship

• Vertical Partition

  Vertically partitions a table

• Horizontal Partition

  Horizontally partitions a table

• Roll-Down denormalization

  Rolls down two tables and creates a single denormalized table

• Roll-Up denormalization

  Rolls up two tables and creates a single denormalized table

• Supertype-Subtype Identity

  Creates an identifying relationship between a supertype entity and its subtype entities

• Supertype-Subtype Rollup

  Rolls up all primary key and non-key attributes in the subtype entities to the supertype entity

• Supertype-Subtype Rolldown

  Rolls down all primary key and non-key attributes in a supertype entity to the subtype entities

• Column denormalization

  Copies a column from one table to another, and then link the two columns (column denormalization)

• Show Transform Source Objects

  Changes the display of transforms in the active model to show the transform source objects. Applies to all transforms. To change the display for one transform, right click the transform name in the Model Explorer and select Show Source Objects

• Show Transform Target Objects

  Changes the display of transforms in the active model to show the transform target objects. To change the display for one transform, right click the transform name in the Model Explorer and select Show Target Objects

• Reverse All Transforms

  Reverses all transforms in the active model

• Resolve All Transforms

  Resolves all transforms in the active model