A requirements driven approach to data warehouse consolidation

Abstract

Data mart consolidation does schema as well as data integration of data marts so as to produce a single physical data mart/warehouse. This implies that multiple data marts must exist. Our proposal is to integrate requirements specifications of data marts. This upstream integration saves the effort of downstream activities performed when data marts are independently developed and then integrated. Without this integration, we get a new problem of loss of business control. Our integration approach is organized in five steps.