You are here:
Service CoDE
»
Enseignement
»
INFOH419 Data Warehousing - Week 9
This is an old revision of the document!
Table of Contents
Small Summary
Slides
Reading material
Exercises
INFOH419 Data Warehousing - Week 9
Small Summary
ETL process
Transform/Cleanse
Load
Slides
Slides Transform-Load
Reading material
ETL: Sec. 1.3, 1.4; Ch. 10 of Golfarelli and Rizzi book
Exercises
ETL Update Exercise
the (incomplete)ETL package
Create table statements for the data warehouse
Create table statements for the updates database
The dates source text file
Solutions
SSIS Package
Solution Explanation
On the database server, a database with some example updates has been made avaailable for testing purposes. The name of this database is “W9-updatesNorthwind”.
teaching/dw2013-w9.1385504241.txt.gz
· Last modified: 2013/11/26 23:17 by
tcalders