Data Warehouse Design Considerations


Data Warehouse Design Considerations. This presentation covers the following topics :

  • Slowly Changing Dimensions
  • Understanding Indexing
  • Indexing the Data Warehouse
  • Understanding Index Views
  • Understanding Data Compression
  • Data Lineage
  • Using Partitions
  • Identifying Fact / Dimension Tables

For more presentations regarding this subject, use this link.

UpScale Analytics is one of the largest platforms in the world for learning SQL by doing, consisting over 300 SQL exercises at different levels (including solutions), by topics, across over 100 different datasets. More…