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:
Resolves a many-to-many relationship
Vertically partitions a table
Horizontally partitions a table
Rolls down two tables and creates a single denormalized table
Rolls up two tables and creates a single denormalized table
Creates an identifying relationship between a supertype entity and its subtype entities
Rolls up all primary key and non-key attributes in the subtype entities to the supertype entity
Rolls down all primary key and non-key attributes in a supertype entity to the subtype entities
Copies a column from one table to another, and then link the two columns (column denormalization)
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
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
Reverses all transforms in the active model
Resolves all transforms in the active model
| Copyright © 2011 CA. All rights reserved. | Email CA Technologies about this topic |