Skip to Content
0
Former Member
Jun 24, 2009 at 04:27 PM

How to find records that are skipped in Transformation File

287 Views

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.