[tang8330]

Hm, perhaps I wasn't being clear, apologies for that.

What I am proposing above is ways to provide a view to teams that do not want real-time data while keeping your underlying dataset in real-time.

[mbesto]

Huh? The parent's point was your underlying dataset is always in real-time. There's no issue querying a data warehouse when all you're doing is looking for a simple transactional report.

[shrimpx]

I think their point is they have a real-time warehouse that can also be used in “stale snapshot” mode.