Understanding Data Set Validation
The purpose of Data Set validation (Validate/Check Integrity) is to check data validity based on rules defined on record fields (metadata), for example, whether a field value can be empty. Data can be validated from either the project file (Validate) or database (Check Integrity). The validation rules are always stored as metadata in database.
Validation
Data will be validated come from project file.
Check Integrity
Data will be validated come from database.
There are two types of validation:
Basic Validation
Provides the default validations.
Custom Validation
Extension application class (defined in the Data Set Definition) that extends the base validation class to define specific validation logic.
Basic Validation
Basic validation is used to check that the data set instances in a project are correct against their metadata in the database. This table lists the validations performed:
Validation Operation |
Description |
---|---|
Translate |
For record fields defined as edit type Translate Table Edit, check if field value is in the translate table. |
Yes/No |
For record fields defined as edit type Yes/No Table Edit, check if all yes/no fields contain yes or no data only. |
Required |
For record fields defined as Required, check if all Required fields contain data. |
Prompt |
For record fields defined as edit type Prompt Table Edit, check if the field value is contained in the prompt table. |
Reference |
For references defined in Relations in the Data Set Designer, check if the references for data set instances in the project are correct. |
When and Where to Run Validation
Validation and Check Integrity can be run in various stages in the data migration process. When they are run will determine the validation that takes place.
Check Integrity
Stage
Database
UI Control
Description
Before Copy to File
Source
Check Integrity button
Performs all basic edits.
Before Compare/Copy From File
Target
Check Integrity button
Performs all basic edits.
Copy From File
Target
Check Integrity After Copy checkbox on the Copy From File page
Performs all basic edits.
After Copy From File
Target
Check Integrity button
Performs all basic edits.
Validate
Stage
Database
UI Control
Description
Before Compare/Copy From File
Target
Validate button
Performs translate, Yes/No, and Required edits, does not include prompt and reference edit.
Compare From File
Target
Validate Project checkbox on Compare From File page
Performs translate, Yes/No, and Required edits, does not include prompt and reference edit.
Copy From File
Target
Validate Project checkbox on Copy From File page
Performs translate, Yes/No, and Required edits, does not include prompt and reference edit.