Reporting data validation results
One of the advantages of using the Validation transform is that Data Services provides the reporting functionality which is based on validation statistics and collected sample data during validation processes.
Validation reports can be viewed in the Data Services Management Console. In this recipe, we will learn how to collect data for validation reports and access them in the Data Services Management Console.
Getting ready
Use the same job and dataflow, DF_Extract_Address,
updated with the Validation transform as in the previous recipes of the current chapter.
How to do it…
Open the dataflow
DF_Extract_Address
and double-click on the Validation transform object to open it for editing.Note
To be able to use Data Services validation reports, the validation statistics collection has to be enabled first for a Validation transform object in the ETL code structure that you want to collect the reporting data for.
Open the Validation Transform Options tab in the Validation...