Removing a Denormalization as Well as the Associated Tables:

You remove a denormalization as well as the associated tables as follows:

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

   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.