Mapping Specification Validation
Validate the mapping specification to verify that the mapping specification has no errors. You can validate a mapping specification during different stages of the mapping specification development cycle. You must load a valid mapping specification to a target.
You can validate a mapping specification at the following stages of development:
- •During the mapping specification development cycle.
- •When you preview the results of the mapping specification.
- •When you load the results of the mapping specification to the target.
- •When you export the mapping specification logic to PowerCenter.
- •When you export the mapping specification logic as a virtual table.
When a validation error occurs, the mapping specification is not valid. The Analyst tool cannot load the results of the mapping specification to the target, or export the mapping specification logic as a virtual table or to PowerCenter .
Validation Errors During Mapping Specification Development
Validation errors might occur during mapping specification development.
The following validation errors can occur during the mapping specification development cycle:
- •The mapping specification does not contain a target.
- •The mapping specification contains expressions, rules, aggregators, filters, lookups, or joins that are not valid.
- •The mapping specification contains a source that was deleted or modified in the Model repository.
- •The mapping specification contains source and target column relationships that are not valid because of incompatible datatypes.
Validation Errors During Data Preview
Validation errors might occur when you preview the results of a mapping specification.
The following validation errors can occur when you preview the results of a mapping specification:
- •The mapping specification contains expressions, rules, aggregators, filters, lookups, or joins that are not valid.
- •The mapping specification contains source and target column relationships that are not valid.
Validation Errors During a Load Operation to the Target
Validation errors might occur when you load the results of a mapping specification to the target.
The following validation errors can occur when you load the results of a mapping specification to the target:
- •The mapping specification contains expressions, rules, aggregators, filters, lookups, or joins that are not valid.
- •The mapping specification contains source and target column relationships that are not valid because of incompatible datatypes.
- •The structure and properties of the mapping specification target does not match the structure and properties of the target data object.
- •The target data object does not exist in the Model repository.
- •The database connection for the target data object contains incorrect database connection properties.
- •The database connection for the target data object is deleted.
- •You do not have permission to use the database connection for the target data object.
- •The Data Integration Service for the Analyst Service is disabled or becomes disabled during the load operation.
- •The Model Repository Service is disabled or becomes disabled during the load operation.
- •The Mapping Service module for the Data Integration Service is not available.
- •The source data object in the mapping specification is the same as the target data object to which you want to load the mapping specification results.
- •The mapping specification contains Developer tool sources that are not valid.