Explain a time you had to troubleshoot a complex data integration issue between two distinct systems. Write a PostgreSQL query that compares records from two systems and identifies integration discrepancies, including records missing from either system and differences in amount or status.
issue_type.integration_key in ascending order.| Column | Type | Description |
|---|---|---|
| record_idPK | INT | Source system record identifier |
| integration_key | VARCHAR(20) | Business key used to match records across systems |
| amount | NUMERIC(12,2) | Amount recorded by the source system |
| status | VARCHAR(20) | Source system record status |
| updated_at | DATE | Date the source record was updated |
| Column | Type | Description |
|---|---|---|
| record_idPK | INT | Target system record identifier |
| integration_key | VARCHAR(20) | Business key used to match records across systems |
| amount | NUMERIC(12,2) | Amount recorded by the target system |
| status | VARCHAR(20) | Target system record status |
| updated_at | DATE | Date the target record was updated |