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 the property sheet of this object, select Model > Transformations to open the List of Transformations, select the appropriate denormalization, and then click the Properties tool.

The General tab contains the following properties:

Property	Description
Name/Code/Comment	Identify the object. The name should clearly convey the object's purpose to non-technical users, while the code, which is used for generating code or scripts, may be abbreviated, and should not normally include spaces. You can optionally add a comment to provide more detailed information about the object. By default the code is generated from the name by applying the naming conventions specified in the model options. To decouple name-code synchronization, click to release the = button to the right of the Code field.
Partitioned table	[partitionings only] Specifies the name of the table used to create the table partitions.
Discriminant Columns	[horizontal partitionings] Specifies the name and code of the columns used as partition criteria.
Target table	[collapsings] Specifies the name of the table resulting from the collapsing of the tables.

The following tabs are also available:

Partitions - [partitionings] Lists the tables associated with the partitioning. You can create or delete partition tables, and edit their properties. If you delete a partition, you are prompted to specify whether you want to delete the corresponding table.
Partition Columns - [vertical partitionings] Displays the distribution of columns between the partition tables. You can drag and drop columns between tables.
Source Tables - [table collapsings] Lists the tables that were collapsed. These tables will no longer exist unless you selected to keep them in the wizard.