Describe how you verify that web metrics align with downstream database records through test cases you would build.
Use the provided web_metrics and database_records tables to produce a test result for every metric and date appearing in either source. Treat multiple downstream records for the same metric and date as one combined value, and identify missing values or discrepancies.
metric_date, metric_name, web_value, database_value, variance, and test_statusmetric_date, then metric_name| Column | Type | Description |
|---|---|---|
| metric_idPK | INT | Unique web metric row identifier |
| metric_date | DATE | Date represented by the web metric |
| metric_name | VARCHAR(50) | Name of the tracked web metric |
| web_value | DECIMAL(12,2) | Metric value reported by the web measurement system |
| Column | Type | Description |
|---|---|---|
| record_idPK | INT | Unique downstream record identifier |
| record_date | DATE | Date represented by the downstream record |
| metric_name | VARCHAR(50) | Name of the downstream metric |
| record_value | DECIMAL(12,2) | Value contributed by the downstream record |