datawarehousing topics

# Data warehouse architectures
# New view of dimensional modeling
# Required snowflakes
# Conforming facts and dimensions
# Heterogeneous dimensions and facts
# Changing dimensions and facts
# Mixed changes
# Modeling for different types of time changes
# Fact to fact joins
# Do all facts have count, amount; are all dimensions without them.
# Factless facts.
# Fact or dimension
# Design for parallel
# Multiple roles
# Use of surrogate keys
# Handling multi-valued dimensions
# Dimensions with varying characteristics
# Handling complex dimensions, such as hierarchical, ragged, multiple dimensions
# Handling time and history
# Surrogate keys
# Name value pairs
# What changed?
# Name value pairs
# Detecting change data
# Problems with flattening T1 and T2 dimensions
# Designing aggregates
# Aggregates vs. on-the-fly
# Supporting restatement or aggregates
# Predicate analysis for star joins
# Designing for trickle load
# Exercises