Chapter 7 Denormalizing a PDM

Revert a table collapsing

The revert feature is used to recover the original tables used for collapsing. This procedure does not apply if you have kept the original tables.

Revert is not a single-click operation, you have to perform several actions as described in the procedure below. Revert is only accessible if the collapsed tables are generated objects proceeding from a PDM, CDM, or OOM generation into a PDM, otherwise you will not be able to recover the collapsed tables.

To revert a table collapsing:

1. Select a table collapsing object in the List of Transformations.
2. Click the Cancel Transformation tool in the list toolbar in order to initiate the revert process.
   
   
      Cancel Transformation tool
   The Cancel Transformations tool is disabled if the table is not a generated object
   
   
   
   The table collapsing object is removed from the list.
3. Click OK.
   
   The table collapsing and resulting table are deleted from the PDM.
4. Regenerate the PDM in update mode.
   
   Since the transformation object is no longer in the model, the merge dialog box lets you recreate the original table used for the collapsing. You have reverted the table collapsing.

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