Using the Vertical Partitioning Wizard

Chapter 7 Denormalizing a PDM

Using the Vertical Partitioning Wizard

The Vertical Partitioning Wizard lets you generate multiple tables from a selected table. The generated tables correspond to partitions of a table.

The key columns of the partitioned table are duplicated whereas the other columns are distributed among the partition tables. PowerDesigner verifies that all the columns of the partitioned table are used in the partition tables.

You can keep the original table used for the partitioning.

The Vertical Partitioning Wizard is accessible from the Tools menu or the contextual menu of a table. The wizard lets you define the following parameters:

Wizard page	Description
Partitioned Table Selection	Lets you select the table to partition in any package of the current model. If a table is selected in the diagram, it appears in the Partitioned Table box. If you select the Keep the Partitioned Table After the Partitioning check box, you preserve the original table used for the transformation
Partition Definition	Lets you define the partitions of the selected table. You can use the Insert or Add a row tools to create as many partitions as needed. The name of each partition is unique in the model. A table will be created for each partition using the partition name
Partition Column Selection	Lets you define the columns to include in each partition table. You can use the Add button to add columns from the partitioned table to the partition tables. The key columns do not appear in the list because they are duplicated in each partition table. Include each column in a partition and click Next
Partitioning Information	Lets you enter a name and a code for the transformation object that will be created together with the partitions. In this documentation, we shall call this object vertical partitioning object

To use the Vertical Partitioning Wizard:

Select Tools→Denormalization→Vertical Partitioning.

or

Right-click a table in the diagram and select Vertical Partitioning from the contextual menu.

The Vertical Partitioning Wizard appears.

Select a partitioned table.

<optional> Select Keep the Partitioned Table After the Partitioning check box.

Click Next.

Define the partitions to generate and click Next.

Select the columns to include in each partition and click Next.

Define the name and code of the vertical partitioning object and click Finish.

After the creation of the partitions and their corresponding tables, the partitioned table is deleted from the model. All references incoming or outgoing the partitioned table are recreated on each partition table.

A vertical partitioning object is created each time you perform a vertical partitioning on a table.