O'Reilly logo

Pro SQL Server 2012 Integration Services by David Dye, Michael Coles, Francis Rodrigues

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

C H A P T E R  17

Dimensional Data ETL

We are not in the eighth dimension; we are over New Jersey. Hope is not lost.

Adventurer Buckaroo Banzai

In the first decade of the 21st century, the terms data warehouse and data mart were suddenly—and without warning—copied and pasted all over every database professional’s résumé. Despite the apparent increased awareness in the professional community, the core components of these structures, dimension and fact tables, remained misunderstood. In this chapter, you’ll look at ways to load data efficiently into your dimensional structures. You’ll begin with an introduction to the terminology and concepts used throughout this chapter.

Introducing Dimensional Data

By now, most database professionals have had ...

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