How does a federated DW architecture work?
A federated DW architecture shares as much core information among the various systems as possible. This is accomplished by sharing critical master files or dimensions, common metrics and measures, and other high-impact data across all systems that can make use of the information. It is usually accomplished via an enterprise-class ETL tool, which provides a common meta data repository, and the use of common data staging areas.
