How do you handle data integrity issues when merging information from disparate sources like EDW and local Access databases?
Using the supplied EDW and Access tables, write a query that produces one reconciled row per asset code and identifies records requiring review.
asset_code, the EDW-preferred merged asset attributes, integrity_status, and the number of Access records received.asset_code ascending.| Column | Type | Description |
|---|---|---|
| edw_asset_idPK | INT | EDW asset record identifier |
| asset_code | VARCHAR(20) | Business identifier used to match sources |
| asset_name | VARCHAR(100) | Standardized asset name |
| lifecycle_status | VARCHAR(30) | Current lifecycle status |
| site_code | VARCHAR(20) | Facility or site identifier |
| last_verified_date | DATE | Date the EDW record was last verified |
| Column | Type | Description |
|---|---|---|
| access_record_idPK | INT | Local Access record identifier |
| asset_code | VARCHAR(20) | Business identifier supplied by the local database |
| asset_name | VARCHAR(100) | Asset name from the local database |
| lifecycle_status | VARCHAR(30) | Local lifecycle status |
| site_code | VARCHAR(20) | Local facility or site identifier |
| imported_at | TIMESTAMP | Timestamp when the record was imported |