In previous article, I compared two approaches in designing data-warehouse, Inmon and Kimball. Today, I would like to go some basic concepts in Kimball approach. What kind of dimension tables? What kind of fact tables? And how are hierarchies?
To make it simple and easy to understand. I have drawn the image “A picture is worth a thousand words”.