Most of the data warehousing done, posses three tier architecture.
The base level from which data is extracted is operational system(oltp) and the lagacy systems, from which data is transformed and loaded into the warehouse darabase. So the middle level is the data warehouse and the top most level is the analytic system(olap). OLAP systems utilize the data warehouse to proivide multi dimensional view. Functionally a data warehouse can be divided into following:
- Data Extraction
- Transformation and Scrubbing
- Data Loading
- Data Analysis
- Data Delivery
No comments:
Post a Comment