OneNoughtOne
0/308
Loading content...
A workforce data platform ingests employee identity details and compensation records from separate systems. Data quality checks must identify IDs where one side is missing.
Table: employee_directory
Table: payroll
Data guarantees:
Incomplete profile definition: An employee record is incomplete when employee_id exists in exactly one table.
Task: Return every employee_id that has incomplete profile coverage.
Output requirements:
Supported submission environments:
employee_directory:
| employee_id | name |
|-------------|----------|
| 2 | Crew |
| 4 | Haven |
| 5 | Kristian |
payroll:
| employee_id | salary |
|-------------|--------|
| 5 | 76071 |
| 1 | 22517 |
| 4 | 63539 |[
{"employee_id":1},
{"employee_id":2}
]Explanation
Employee 1 appears only in payroll, and employee 2 appears only in employee_directory. IDs 4 and 5 exist in both sources and are complete.
employee_directory:
| employee_id | name |
|-------------|---------|
| 10 | Alex |
| 11 | Bianca |
payroll:
| employee_id | salary |
|-------------|--------|
| 10 | 80000 |
| 11 | 90000 |[]Explanation
Every employee_id appears in both tables, so there are no incomplete records.
employee_directory:
| employee_id | name |
|-------------|-----------|
| 100 | Priya |
| 200 | Omar |
| 350 | Linh |
| 700 | Gabriel |
payroll:
| employee_id | salary |
|-------------|--------|
| 50 | 72000 |
| 100 | 81000 |
| 700 | 95000 |
| 900 | 66000 |[
{"employee_id":50},
{"employee_id":200},
{"employee_id":350},
{"employee_id":900}
]Explanation
The result is the symmetric difference of IDs across both tables.
Constraints