Data-warehouse concepts in Kimball approach

Introduction 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 … Continue reading Data-warehouse concepts in Kimball approach

Advertisements

The differences between Kimball and Inmon approach in designing data-warehouse

If you are working in data warehousing project or going to work on data warehouse project, the two most commonly designed methods are introduced by Ralph Kimball and Bill Inmon. Which advantages  / disadvantages of these approaches? Which one is better/ suitable for your business requirement? Lets understand the basic difference between Ralph Kimball and … Continue reading The differences between Kimball and Inmon approach in designing data-warehouse