Chapter 7 Denormalizing a PDM


Using the Column Denormalization Wizard

The Column Denormalization Wizard lets you duplicate columns in a selected table. The result is a column replica object in the target table.

For more information on replications, see chapter Managing Object Replications in the General Features Guide .

The Column Denormalization Wizard is accessible from the Tools menu or the contextual menu of a table. The wizard lets you define the following parameters:

Wizard page Description
Target Table Selection Lets you select the table in which you will duplicate one or several columns. If a table is selected in the diagram, it appears by default in the Target Table Selection box. you can use
Selection Lets you select one or several columns that will be duplicated in the selected table

Steps To use the Column Denormalization Wizard:

  1. Select Tools→Denormalization→Column Denormalization.

    The Column Denormalization Wizard appears.
  2. Select the table in which you want to duplicate columns and click Next.
  3. Select the columns to duplicate and click Finish.

A replica is created for each duplicated column.

You can display the list of replica from the menu command Model→Replications. Each replica has a property sheet with details about the replicated object, replicated attributes, replicated collections (association between metaclasses in the metamodel), and sub-replications.

For more information on replica, see chapter Managing Object Replications in the General Features Guide .

You can move and paste a denormalized column into another model or package using the standard copy/paste or cut/paste features.

 


Copyright (C) 2005. Sybase Inc. All rights reserved.