Validation of Imported Records

You can use the PrepareForImport activity to prevalidate incoming data by passing in a rulebase and to set the PRODUCTID and PRODUCTIDEXT. It is required that PRODUCTID and PRODUCTIDEXT be generated or otherwise assigned at this stage. Irrespective of a rulebase supplied to this activity, all repository attributes are validated for data format and length. The validation of relationship attributes is not performed because relationships are not recognized at this step.
  • ValidateOnly mode: The ValidateOnly mode does not save the incoming data to database. It reads the data from input map and performs the validations. You can specify this flag in two ways during import:
    • Use the ValidateOnly parameter of the PrepareForImportCatalog activity: you need to modify the workflow to configure the ValidateOnly parameter. After the PrepareForImportCatalog activity, the workflow terminates with the Success status, that is, no other import activity should be executed.
    • Select the Validate Only check box when initiated import from the Start Import screen: When the Validate Only check box is selected, the workflow only validates the data and generates an error report and a log file. The workflow terminates after the PrepareForImportCatalog activity and does not continue with the ImportCatalogRecords activity.
Note: If the ValidateOnly parameter is specified in the activity, it takes precedence over the runtime parameter.

For more information on the ValidateOnly parameter, refer to TIBCO MDM Workflow Reference.