Downloadable example of a normalize Inmon Enterprise Data Warehouse

Question

I am familiar with Kimball data warehouses, but I have never seen an Inmon data warehouse. With all my research, I'm looking for a real example. I understand that Inmon data warehouses are normalized and work with a top down approach.

Is there a downloadable example of this similar to the AdventureWorks databases that Microsoft offers? I'm looking for how the transactional data from a OLTP database is normalized into an enterprise data warehouse.

Answer 1

Transactional data from an OLTP data is already normalized and so the Inmon DW will look very similar to that. However the Inmon DW (or at least the ODS part of it) will be modelled independently of the OLTP system and model the business concepts, with little or no concern about things needed for OLTP transactions. It is probably easiest to use the Adventureworks OLTP database as your template for considering this.