PowerDesigner - Generation of Test Data

Card Puncher Data Processing

About

How to create Test Data from Power Designer.

In Power Designer, Test Data Profiles (Metadata) permits you to define the definition of the data that you want generate but is not mandatory. The Test Data Profiles are then attached the columns.

Below is written a little “how to”.

Steps

Creation of the Data Profiles

Powerdeisgner Test Data Profiles

You can assign test data profiles directly to columns:

  • that are not attached to a domain,
  • or if you want to generate test data that is specific to a column.

You cannot assign a test data profile to a foreign key column because it automatically takes the data profile of the primary key column in the parent table.

Powerdesigner Column Data Profile

If you do not see the column “Test Data Profiles”, you can:

Generation of the Test Data

In the Menu > Database > Generate Test Data.

During the generation, for a foreign key, PowerDesigner automatically takes the data profile of the primary key column in the parent table.





Discover More
Card Puncher Data Processing
Sybase PowerDesigner

is a data modelling software. The PowerDesigner modeling environment supports several types of models: to model the overall logical structure of a database, independent from any software...



Share this page:
Follow us:
Task Runner