Illustration repma003.gif shows four tables. The employees table at ny.com and the employees table at sf.com are replicas. Here are the tables and their contents:
employees Table at ny.com
employee_id |
last_name |
department_id |
salary |
commission_pct |
|---|---|---|---|---|
100 |
Jones |
20 |
55,000 |
.4 |
101 |
Kim |
20 |
62,000 |
.25 |
102 |
Braun |
20 |
43,500 |
.1 |
employees Table at sf.com
employee_id |
last_name |
department_id |
salary |
commission_pct |
|---|---|---|---|---|
100 |
Jones |
20 |
55,000 |
.4 |
101 |
Kim |
20 |
62,000 |
.3 |
102 |
Braun |
20 |
43,500 |
.1 |
103 |
Rama |
20 |
48,750 |
.35 |
missing_rows_data Table
employee_id |
salary |
commission_pct |
rowid |
|---|---|---|---|
101 |
62,000 |
.25 |
000015E8.0000.0002 |
101 |
62,000 |
.3 |
000015E8.0001.0002 |
103 |
48,750 |
.35 |
000015E8.0002.0002 |
missing_rows_location Table
present |
absent |
r_id |
|---|---|---|
ny.com |
sf.com |
000015E8.0000.0002 |
sf.com |
ny.com |
000015E8.0001.0002 |
sf.com |
ny.com |
000015E8.0002.0002 |