Chapter 1. Data Warehouse Logical Design
Exam objectives in this chapter:
Design and Implement a Data Warehouse
Design and implement dimensions.
Design and implement fact tables.
Analyzing data from databases that support line-of-business (LOB) applications is usually not an easy task. The normalized relational schema used for an LOB application can consist of thousands of tables. Naming conventions are frequently not enforced. Therefore, it is hard to discover where the data you need for a report is stored. Enterprises frequently have multiple LOB applications, often working against more than one database. For the purposes of analysis, these enterprises need to be able to merge the data from multiple databases. Data quality is a common problem as ...