DW arch Inmon vs Kimball in datawarehousing concepts

preview_player
Показать описание
DW arch Inmon vs Kimball
Kimball defines data warehouse as “a copy of transaction data specifically structured for query and analysis”. Kimball's data warehousing architecture is also known as data warehouse bus (BUS)
Inmon
The data warehouse acts as a unified source of truth for the entire business, where all the data is integrated.
#Kimball #Inmon #datawarehousing
Комментарии
Автор

Enterprise Datawarehouse is not normalized and not in the 3nf.
Normalization helps where there are frequent transactions. For analytical and reporting purpose data is kept denormalized.

navdeepjha