Netezza

To create a PDM with support for features specific to the Netezza DBMS family, select the appropriate version in the DBMS field of the New Model dialog. To view these extensions to the PowerDesigner metamodel in the Resource Editor, select Database > Edit Current DBMS and expand the Profile node.

The following sections list the extensions provided for Netezza.

Tables

The following extensions are available on the General tab.

Name

Description

Distribution

Specifies the type of row distribution. You can choose between None, hash, and random.

Scripting name: Distribution

Column(s)

[hash distribution] Specifies the hash distribution columns.

Scripting name: DistributeOnExplicitColumnList