Removing Partitionings and Table Collapsings

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

Select Model > Transformations to open the List of Transformations, and then click the :

Cancel tool - to remove the denormalization as well as the associated tables. Note that this 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.
Delete tool - to remove the denormalization but keep the associated tables.

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