This chapter is setting the scene. It provides the end to end high level landscape of Data Warehouse. Much of this chapter talks on how Data Warehouse is different from Transaction systems, and what are we in for. Lets Look at What & why of Data Warehouse, its components & framework and what are the challenges for a typical DW project.
Data Warehouse framework starts from extracting data from source systems, transforming and cleansing it, before loading into the repository. It ends with the data being accesses, analyzed, mined and dashboarded using end user tools.