Chapter 4 Building Physical Diagrams

Removing partitionings and table collapsings

You can remove partitionings or table collapsings and either keep or remove the associated tables.

Steps To remove a denormalization and keep the associated tables:

  1. Select Model→Transformations to open the List of Transformations.
  2. Select the denormalization object, and then click the Delete tool.

    The denormalization object (and, for partitionings, its partitions) are deleted, but the corresponding tables are retained, and become independent from each other.

Steps To remove a denormalization as well as the associated tables:

  1. Select Model→Transformations to open the List of Transformations.
  2. Select the denormalization object, and then click the Cancel tool.

    Note   Cancel Transformation tool
    The Cancel Transformation tool is only available if the selected denormalization object is based upon a table generated from another model. You can recover the original table by regenerating it from the source model.



    The denormalization object (and, for partitionings, its partitions) are deleted, as well as the corresponding tables.

Note   Moving denormalizations
You cannot move or paste a denormalization object to another model or package.

 

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