PowerDesigner provides default model checks to verify the validity of data transformation actions.
Check |
Description and Correction |
---|---|
Name/Code contains terms not in glossary |
[if glossary enabled] Names and codes must contain only approved terms drawn from the glossary.
|
Name/Code contains synonyms of glossary terms |
[if glossary enabled] Names and codes must not contain synonyms of glossary terms.
|
Name/Code uniqueness |
Object names must be unique in the namespace.
|
Existence of source object |
A data transformation action must have at least one data structure source object.
|
Existence of data structure column |
At least one data structure column must be defined in the data transformation action.
|
Existence of data structure sorted column [data sort only] |
A data sort must have at least one sort column defined to sort data.
|
Undefined script [script execution and data lookup only] |
A script execution/data lookup must have a script defined.
|
Existence of data connection [data query execution only] |
A data query execution must be linked to a data connection to insert or update data in the database.
|
Undefined source expression for data structure columns [data aggregation only] |
A data aggregation must have at least one source expression defined to aggregate data.
|
Existence of aggregated column [data aggregation only] |
A data aggregation must have at least one aggregation column defined to aggregate data.
|
Undefined criterion [data filter only] |
A data filter must have a criterion defined to filter data
|
Existence of data structure join [data join only] |
A data join must have a data structure defined
|
Missing occurrences in join sources [data join only] |
A data structure join must have two sources defined.
|
Match data structure column sources [data merge only] |
The two data structure column sources of a data merge must be equivalent [same number of data structure columns and same data type ]
|