Holistic Enterprise Data Warehouse Processes Integration

Abstract

Enterprise data warehouse process has been identified into processes like Extraction, transformation, loading and retrieval. Individual processes are a complete system and their smooth integration is required for perfect functioning of a data warehouse solution. One way of integration is to use tools that offer ETL and reporting. Another method is to hire a System Integrator for process integration. This paper aimed at looking in data warehouse processes as holistic system which would be integrated in such a way that all processes seem one process. Streamlining of interdependencies and switching of various threads encountered during processes would be managed effectively.

Keywords: DWH Integration Streamlining ETL ETLR Automation Retrieval