Data Validation Report

Here you can see the results of data validation applied to the original and target data sources to ensure quality.

In This Topic:

Data Validation: File
Data Validation: Table
Data Validation: File and Table

Data Validation: File

Here you can see a comprehensive file-to-file data validation report with mismatches highlighted at file, column, and cell level. It provides a summary of:

Total Files: Total number of files in Data Validation stage.
Status: Provides status of the Data Validation stage.
Description: A brief description of the stage is displayed.
Cell By Cell: Cell-by-cell comparison details.

Functions

The Functions section shows the validation report highlighting the functions that succeeded or failed on files and columns, including:

Source File: Name of the source file.
Target File: Name of the target file.
Total Functions: Displays the total number of functions used for validation.
Applied Functions: Displays the aggregate functions used for data validation.
Total Columns: Displays the number of columns involved in data validation.
Status: Provides status information.

Moreover, a detailed report can be downloaded from the . Click on the preferred file to get more information about the applied functions on the source and target.

Cell by Cell

This section highlights the cell-by-cell comparison report. The left panel shows the total files along with the validation status. The right panel shows the respective information. It includes details of the source and target files, total number of source and target rows, and the validation status.

Click to get more insights into surplus source and target records along with mismatched records.

Surplus Source Records displays the surplus records in source. It showcases a maximum of 50 surplus records.

Surplus Target Records displays the surplus records in target. It showcases a maximum of 50 surplus records.

Mismatch Records displays the mismatch data between source and target. It shows a maximum of 50 mismatch records.

Data Validation: Table

Here you can see a comprehensive table-to-table data validation report with mismatches highlighted at table, column, and cell level. It provides a summary of:

Total Tables: Total number of tables in the data validation stage.
- Matched: Total number of data that match in the source and target.
- Not Matched: Total amount of data in the source and target that did not match.
Status: Provides status of the Data Validation stage.
Description: A brief description of the stage is displayed.
Cell By Cell: Cell-by-cell comparison details.

Functions

The Functions section shows the validation report highlighting the functions succeeded or failed on tables and columns, including:

Source Table: Name of the source table.
Target Table: Name of the target table.
Total Functions: Shows the functions used for validation.
Applied Functions: Displays the aggregate functions used for data validation.
Total Columns: Displays the number of columns involved in data validation.
Status: Provides validation status of the tables.

Moreover, a detailed report can be downloaded from the . Click on the preferred table to get more information about the applied functions on the source and target.

Cell by Cell

This section highlights the cell-by-cell comparison report. The left panel shows the source and target data source along with the validation status. The right panel shows information of the selected data source. It includes details of the source and target tables, total number of source and target rows, and the validation status of the tables.

Click to get more insights.

Data Validation: File and Table

Here you can see a comprehensive file-to-table/ table-to-file data validation report with mismatches highlighted at file/ table, column, and cell level. It provides a summary of:

Total Files: Total number of files in Data Validation stage.
Status: Provides status of the Data Validation stage.
Description: A brief description of the stage is displayed.
Cell By Cell: Cell-by-cell comparison details.

Functions

The Functions section shows the validation report highlighting the functions that succeeded or failed on files or tables and columns, including:

Source File: Name of the source file.
Target Table: Name of the target table.
Total Functions: Displays the total number of functions used for validation.
Applied Functions: Displays the aggregate functions used for data validation.
Total Columns: Displays the number of columns involved in data validation.
Status: Provides status information.

Moreover, a detailed report can be downloaded from the . Click on the preferred file or table to get more information about the applied functions on the source and target.

Cell by Cell

This section highlights the cell-by-cell comparison report. The left panel shows the total files along with the validation status. The right panel shows the respective information. It includes details of the source and target files or tables, total number of source and target rows, and the validation status of the tables.

Click to get more insights into surplus source and target records along with mismatched records.

Surplus Source Records displays the surplus records in source. It showcases a maximum of 50 surplus records.

Surplus Target Records displays the surplus records in target. It showcases a maximum of 50 surplus records.

Mismatch Records displays the mismatch data between source and target. It shows a maximum of 50 mismatch records.