Watch this video on YouTube
What type of database design should you use for a data warehouse when you want to reduce the data volume of your dimensions?