Hello Everyone,
I have a data file that I am using to validate my transformation file. I keep getting skipped records in the validation. However I get a success message and the data file loads successfully into the BPC system. However, I need to find out which records the validation is skipping. Is there a way to find out which
records are being skipped in the transformation file? Below is a copy of what
I get after I validate the data with the transformation file.
[Start validating transformation file]
Validating transformation file format
Validating options...
Validation on options was successful.
Validating mappings...
Validation on mappings was successful.
Validating conversions...
Validation on conversions was successful.
Creating the transformation xml file. Please wait ...
Transformation xml file saved successfully.
Connecting to server ...
Begin validate transformation file with data file...
[Start test transformation file]
Validate has successfully completed
VALIDATE_RECORD Option = YES
[The list of conversion file]
Conversion file: DataManager\ConversionFiles\CATEGORYCONV.XLS!CONVERSION
Conversion file: DataManager\ConversionFiles\ACCOUNT.XLS!CONVERSION
Conversion file: DataManager\ConversionFiles\BUSINESSAREA.XLS!CONVERSION
Conversion file: DataManager\ConversionFiles\COSTCENTER.XLS!CONVERSION
Conversion file: DataManager\ConversionFiles\PRODUCT.XLS!CONVERSION
Conversion file: DataManager\ConversionFiles\ENTITY.XLS!CONVERSION
Record Count : 356384
Accept Count : 355722
Reject Count : 0
Skip Count : 662
This task has succesfully completed.