This shows you the differences between two versions of the page.
| Next revision | Previous revision Last revision Both sides next revision | ||
|
teaching:dw2013-w8 [2013/11/06 09:15] tcalders created |
teaching:dw2013-w8 [2013/11/13 09:22] tcalders |
||
|---|---|---|---|
| Line 13: | Line 13: | ||
| ===== Slides ===== | ===== Slides ===== | ||
| * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/DW07a-indexing.pdf|Slides Indexing]] | * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/DW07a-indexing.pdf|Slides Indexing]] | ||
| - | * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/DW07b-ETL.pdf|Slides ETL]] | + | * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/DW07b-E.pdf|Slides ETL]] |
| ===== Reading material ===== | ===== Reading material ===== | ||
| Line 22: | Line 22: | ||
| ===== Exercises ===== | ===== Exercises ===== | ||
| + | * [[https://dl.dropboxusercontent.com/u/5119252/DW/2013/nwETL.pdf|Exercises]] | ||
| + | * [[https://dl.dropbox.com/u/5119252/DW/ETL-ex/cities.txt|cities.txt]] | ||
| + | * [[https://dl.dropbox.com/u/5119252/DW/ETL-ex/DimTime.xls|DimTime.xls]] | ||
| + | * [[https://dl.dropbox.com/u/5119252/DW/ETL-ex/Territories.xml|Territories.xml]] | ||
| + | * [[https://dl.dropbox.com/u/5119252/DW/ETL-ex/Territories.xsd|Territories.xsd]] | ||
| + | * Additional material: | ||
| + | * [[http://technet.microsoft.com/en-us/library/ms169917.aspx|Link to documentation of SQL Server Integration Services]] | ||
| + | * If you want to do the exercises locally: [[http://archive.msdn.microsoft.com/northwind/Release/ProjectReleases.aspx?ReleaseId=1401|Northwind database]] | ||
| + | | ||