I think you missed the parent's point - your USP is real-time replication. So everything you're proposing makes it not real time. Your USP is now worthless (in that context) and you're competitors are numerous.
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.
Comments
I think you missed the parent's point - your USP is real-time replication. So everything you're proposing makes it not real time. Your USP is now worthless (in that context) and you're competitors are numerous.
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.
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.
I think their point is they have a real-time warehouse that can also be used in “stale snapshot” mode.