Creating an ERD from a PDM

To generate a Entity Relation diagram from a physical data model:

1 Open a physical diagram.

2 Choose Dictionary > Create Data Model > Logical Model.

Options in the displayed dialog box are:

Diagram Name

The default suggestion is the name of the source PDM.

Spaces for - and _

Select this to replace hyphens and underscores in the physical names with spaces in the logical names.

Strip Common Column Name Prefix

Select to remove identical prefixes from the column names when creating attributes and data elements. For example:

Column name

Stripped attribute/data element name.

Cust_ID ==>

Cust_Name ==>

Name

Note Stripping prefixes may cause collisions with existing data elements.