[ChicagoDave]

Operational data stores are not reporting data stores. A healthy system would fire change events to which a reporting system subscribes, placing the data where it belongs in the reporting data model.

[thoraway1010]

Except what happens when change events are dropped.

in SQL, normalized, ref integrity on - you simply never get out of sync.