Construção de um dw

Building data warehouses using open source technologies ­ Michel Jansen

Building data warehouses using open source technologies
Draft version 197 Michel Jansen ([e-mail])

1

Building data warehouses using open source technologies ­ Michel Jansen

1 Table of Contents 1 Table of Contents...................................................................................................................................2 2 Introduction............................................................................................................................................3 2.1 Intended audience...........................................................................................................................3 2.2 Why build a data warehouse..........................................................................................................3 3 Building a data warehouse.....................................................................................................................5 3.1 Designing a dimensional data warehouse......................................................................................5 3.1.1 Asking questions.....................................................................................................................5 3.1.2 Modeling structures................................................................................................................5 3.1.3 Picking a fact grain.................................................................................................................5 3.1.4 Adding dimensions.................................................................................................................6 3.2 Constructing the data warehouse....................................................................................................6 3.2.1 Designing transformations using Spoon.................................................................................7 Some