INFOH419 Data Warehousing - Week 6

• Logical design
  • Dealing with changing dimensions
    • Slowly Changing Dimensions
      • Type I, II, and II
    • Rapidly changing dimensions
      • Mini dimension
  • Specific dimension types
    • Junk dimension
    • Outriggers
    • Degenerate dimension
• Physical level
  • View materialization

• Slides SCD
• Slides materialization

• …

We will be using MS SSAS again. For the problem with the server connection a workaround was found; instead of server name CS-MSSQL use directly the IP-address of the server, that is: 164.15.81.95.

• Exercises