Is Replica Of Anomaly Reporting

How the Is Replica Of check reports a divergence, and where to find the differing rows.

Anomaly Messages

Is Replica Of emits a Shape Anomaly only, one per failed comparison. The message counts the rows that differ and names both containers with their datastores in parentheses:

N records differ between <container> (<datastore>) and <reference> (<reference datastore>)

When the comparison cannot get that far, the message says why instead: that the two containers hold different numbers of records, that one side is empty, that a compared field is missing on one side, or that a compared field is stored as a different type. See Data Diff Anomaly Reporting for the full set, which the two rules share.

The count has no singular form: one differing row still reads 1 records differ.

When a filter is set, the Shape Anomaly message names it at the end of its first sentence, as (applied to records where <expression>). Only the target's filter appears there; a filter set on the reference alone is not named. The exception is the message for two containers holding different numbers of records: when either side carries a filter, that message adds a sentence naming each filter against the container it applied to, ending in only when just one side is filtered. There is no per-row variant: the divergence belongs to the dataset, not to a single row.

What the Numbers Mean

• Differing rows: the rows the comparison could not match, available in the anomaly's source records.
• Row Identifiers: when configured, they are what pairs a target row with its reference row and make the per-row detail readable.

Source Records Behavior

With Row Identifiers configured, the per-row detail is rendered in the Comparison Source Records view, showing each differing row side by side. See Comparison Source Records.

Custom Anomaly Description

Custom Anomaly Description does not apply to this rule. The option replaces the message on Record Anomalies, and Is Replica Of emits a Shape Anomaly only.

See Also