Optimization of Data Warehouse – Reporting Design
Problem Definition:- As per any standard Data Warehouse Project the entities <Transactional DB Source, ETL(Extract, Transform & Load) Process, Analytical DB Destination, UI for Reporting> are being used in the current Process/Project. Before looking in to the problems in the current system design let us first see the current system design: