Validation of mapping

Validation is performed when you modify the mapping definition and select the Validate Mapping option on the Mapping tab. The validation process verifies the Mapping Definition against the data source and ensures that these criteria are met:
  • The specified input data mappings are complete and valid:
    • Contains the variable label, which is a unique variable in the input section.
    • Contains the filename label.
    • Contains a source (data location) table or query. If table is included, the specified table is available in the SCV database. If query is included, the specified query is a valid SQL statement on the SCV database. If the query contains an application variable, the application variable must available.
    • If constants is included:
      • The specified columns available in the specified SCV table or selected by the specified query.
      • All application variables used in constant definitions must be available.
  • The specified output data mappings are complete and valid:
    • Contains the variable label, which is a unique variable in the output section.
    • Contains the filename label to store the resulting data, which is unique in the outputs section of the file.
    • Contains a target (data location) table, which is available in the SCV database.
    • If update_mode is included, the specified value must be Insert or Merge.
      Note: If update_model is included and the value is set to Merge, the target table has a PK definition.
    • If delete_mode is included, the specified value must be Physical or None.
    • If delete_condition is included, the delete_mode must be Physical. The specified condition can be used as a valid SQL WHERE clause on the specified SCV table. The application variable must available, if this condition contains an application variable.
    • If constants is included:
      • The specified columns are available in the specified SCV table.
      • All application variables used in constant definitions must be available.
    • If date_time_format is included, the valid date-time format is yyyy-MM-dd'T'HH:mm:ss'Z' or yyyy-MM-dd HH:mm:ss.
      Note: The script code requires the date values in the output data to be in the specified format.

These messages are displayed during the validation process:

  • If validation is successful, this message is displayed:
    Mapping Validation Mapping is valid.
  • If validation is not successful, this message is displayed:
    Mapping validation Mapping is invalid.
Note: 
  • The validation of the Mapping tab starts with the Name validation.
  • The Validation Errors text box in the Mapping tab provides a list of validation errors related to mapping.