You are here: Service CoDE » Enseignement » INFO-H-419: Data Warehouses » INFO-H-419 : Exercises

INFO-H-419 : Exercises

Multidimensional databases

Dimensional Fact Model

From Operational to Multidimensional Databases

Relational OLAP

Bridge Tables and Changing Dimensions

Extraction Transformation Loading

Exercises
- SQL Server Integration Services: Creating a Project
Update Exercises
- SQL Server Integration Services: SCD Component
- Updates of the Northwind operational database (SQL Server)
Advanced Exercises
- External data for extending the Geography dimension

Indexing

View Materialization

Reporting

Exercises

teaching/infoh419/tp.txt · Last modified: 2023/01/26 23:38 by ezimanyi