What's New in QuerySurge

Root Cause Analysis reports assist testers, developers, architects & analysts with identifying problematic tables & columns.

Root Cause Analysis Reports assist data testers, architects, and analysts determine problematic tables & column

Five new reports have been added to the Reporting View which will further enhance QuerySurge’s ability to share insight into your data testing results. As with most of our other reports they can saved as PDFs or Excel files to share both high-level and detailed views of your testing with team members, managers and business stakeholders

Summary of New Reports

  • Root Cause Analysis Summary provides column-based metrics for all QueryPairs in a given Scenario.
  • Root Cause Analysis Details includes all of the information in the Root Cause Analysis Summary report along with a breakdown of unique and null values for each column in the Source and Target queries.
  • Root Cause Analysis Failures contains all of the metrics found in the Root Cause Analysis Details report but focuses specifically on the columns with failures.
  • QueryPair Mappings Coverage provides the mapping information defined for each of the QueryPairs. This report can be generated for any or all QueryPairs. Users have the option to filter on QueryPair Name or Mapping Name.
  • Query Timing offers a detailed look into the time taken to execute and analyze QueryPairs for a particular scenario.

Root Cause Analysis Reports

Much of the reporting in QuerySurge offers users a look at the row-level metrics of test executions. The Root Cause Analysis reporting allows users to analyze their QueryPairs from a column-level perspective, as quicker way to isolate core data issues. Rather than focusing on the failing rows, this report informs users about QueryPair columns in which there was at least one mismatch. The report also provides a breakdown of the percentage of data failures that exist in each column, as well as the counts of null and unique values. This report can assist data architects, database administrators, and testers in tracking down the problematic columns and tables during ETL development.

There are three flavors of the Root Cause Analysis report (Summary, Detail, Failure). The Detail report starts with two summary-level tables: a listing of the QueryPairs with the most failing columns, and a listing of the Source/Target column pairs with the greatest percentage of data failures. The body of the report shows a detailed analysis for each Source/Target column pair. It includes the data failures by count and percentage, as well as unique and null value counts and percentages. Lastly, any QueryPairs excluded from the analysis are listed in the final section of the report.

NOTE: Only QueryPairs that (a) have been configured with Shared Keys and (b) which have no errors can be included in the Root Cause Analysis reporting.

The other two Root Cause Analysis reports (Summary and Failure) are derived from the Detail report. The Summary report provides the same information as the Detail report, minus the unique and null value metrics per column. The Failures report provides the same breadth of information

as the Detail report, but includes only failing QueryPairs and Source/Target column pairs

Top QueryPairs by Failing Column Count

The Top QueryPairs by Failing Column Count summary table shows the QueryPairs in the Scenario with the greatest number of failing columns. This table will display up to ten QueryPairs, and is designed to give a summary-level view of your most problematic QueryPairs from the column perspective.

click to enlarge

Top Columns by Data Failure Percentage

The Top Columns by Data Failure Percentage summary table represents the column pairs in each of the QueryPairs in the Scenario with the greatest percentage of data failures. This table will display up to ten QueryPairs, and is designed to give a summary-level view of your most problematic columns (along with the associated QueryPair).

click to enlarge

Column Analysis Summary

The Column Analysis Summary table offers a broad range of information. It displays each source/target column pair, along with their row counts, non-matching rows, and data failure counts and percentages. Column pairs are grouped by their associated QueryPair, and QueryPairs are further grouped by their parent Test Suites.

click to enlarge

Detailed Column Analysis

The Detailed Column Analysis table offers all of the information displayed in the Column Analysis Summary table, along with a breakdown of unique and null values in each column. For each column on the source and target side of the QueryPair, this table will provide row count, unique value count and percentage, and null value count and percentage figures. This table is only available in the Root Cause Analysis Detail and Root Cause Analysis Failure reports.

click to enlarge

QueryPair Mappings Report

The QueryPair Mappings report will display an overview of the mapping requirements and the QueryPairs that satisfy those requirements. Users can specify which QueryPairs and mappings are included by entering filter criteria prior to running the report. The mapping and description fields.

click to enlarge

QueryPair Timing Report

The QueryPair Timing report shows run time metrics for all QueryPairs in a given scenario. The Overview section will provide the overall Scenario outcome and duration along with average query run times for Source and Target queries. The individual QueryPair Outcome, Source and Target Query times also included in the Query Execution Times table.

click to enlarge

click to enlarge