Several years ago I worked on an ODS system where data was getting fetched from an OLTP database in the form of Materialized Views (M-Views). The M-Views were exact replicas of source tables that were replicated after 1-2 hours, and had an additional column specifying when they were last refreshed. The purpose of ODS was [...]
