Denormalization object properties

Chapter 4 Building Physical Diagrams

Denormalization object properties

A denormalization transformation object is automatically created when you partition a table using the Horizontal or Vertical Partitioning Wizard or collapse tables with the Table Collapsing Wizard.

To access this object, select Model→Transformations to open the List of Transformations, select the appropriate object, and then click the Properties tool.

The following properties are available on the General tab:

Property	Description
Name	Specifies the name of the partitioning object. It is recommended to provide a clear name in the Partitioning Wizard
Code	Specifies the code of the partitioning object
Comment	Specifies additional information about the partitioning object.
Partitioned table	[partitionings only] Specifies the name of the table used to create the table partitions.
Discriminant Columns	[horizontal partitionings only] Specifies the name and code of the columns used as partition criteria
Target table	[table collapsings only] Specifies the name of the table resulting from the collapsing of selected tables

Partitions tab

The Partitions tab is only available for partitionings, and lists the tables associated with the partitioning. The following actions can be performed on this tab:

Open the property sheets of the partition tables.
Add more partitions and edit the properties of the corresponding tables.
Add comments to identify the different partitions
Delete partitions and their corresponding tables. When you delete a partition, you are prompted to specify whether you want to delete the corresponding table. You can delete a partition and keep its table, but you cannot delete a table and keep an empty partition

Partition Columns tab

The Partition Columns tab is only available for vertical partitionings, and displays the distribution of columns between the partition tables. You can drag and drop columns to reallocate them between tables.

Source Tables tab

The Source Tables tab is only available for table collapsings, and displays the tables that were collapsed. These tables will no longer exist unless you selected to keep the original tables in the Table Collapsing Wizard.