Fictional cutover: six rows on both sides
d6e0d47a686e6ad49102aa0338286a66162844dd26ed756c1f44b6542e9c145fa3498f4c78e9c18256932a1aa77811bf71982d71d83438770db2ce7b02820244d55aa851daae6f93d68595b45801ddb1b4aa687fbc46987b612c5d38842c36113db364741d91d0d4436c3ee1e4d1d402057f9906a286f02586f165b316c9a36c| Bucket | Rows | Meaning |
|---|---|---|
| matched | 1 | present in target, every compared field equal after declared normalisation |
| changed | 1 | present in target, at least one compared field differs |
| unverified | 1 | present in target, but a compared field was blank under blank_policy=unknown |
| missing | 1 | no target row and no declared rejection |
| rejected | 0 | declared in the rejects file with a stated reason |
| rejected_but_present | 1 | declared rejected, yet a target row exists |
| duplicate_source | 0 | key occurs more than once in source |
| ambiguous_target | 1 | target holds more than one row for this key; nothing to compare against |
| blank_key | 0 | key columns are empty |
| total | 6 | rows read from file: 6 |
| Bucket | Rows | Meaning |
|---|---|---|
| accounted | 4 | matched to exactly one source row |
| orphan | 0 | present in target, absent from source |
| duplicate_target | 2 | key occurs more than once in target |
| ambiguous_source | 0 | source holds more than one row for this key; cannot be attributed |
| blank_key | 0 | key columns are empty |
| total | 6 | rows read from file: 6 |
| Side | Bucket | Key | Line | Detail |
|---|---|---|---|---|
| source | ambiguous_target | 106 | 7 | target holds 2 rows for this key; no single row can be compared against |
| source | changed | 103 | 4 | balance: source=3000 target=3200 |
| source | missing | 102 | 3 | no target row and no declared rejection |
| source | rejected_but_present | 104 | 5 | declared rejected (Excluded by the fictional review decision) but present in target |
| source | unverified | 105 | 6 | balance: source=<unknown> target=<unknown> |
| target | duplicate_target | 106 | 6 | key appears 2 times in target |