O'Reilly logo

SQL Server 2017 Integration Services Cookbook by Dejan Sarka, Matija Lah, Christian Cote

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Introduction

Once the framework is set up, it's time to focus on the different layers of our data warehouse. There are various architectural schools of thought when it comes to data warehouses:

  • Corporate Information Factory (CIF)
  • The Kimball Group dimensional data warehouse
  • Data vault

The main difference between the Kimball Group and the others is the way a datamart is loaded. The Kimball Group approach loads data into a staging area and from there, refreshes the data warehouse. The latter is modeled as a dimensional data warehouse. It is also known as a datamart or star schema. The Kimball Group approach uses denormalized tables in its data warehouse.

A typical data warehouse using the Kimball Group method has the following components: ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required