Table of Contents
Small Summary
Supporting material
Exercises
INFOH419 Data Warehousing - Week 6
Small Summary
Advanced Dimensional modelling and hierarchies
ETL
Supporting material
Slides
Chapter 3 of the book by Jensen et al.
Exercises
Build the ETL package described in the following file:
description + solution
Some files you will need:
cities.txt
DimTime.xls
Territories.xml
Territories.xsd