O'Reilly logo

Connecting the Data by Angelo R. Bobak

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

CHAPTER 10

Data Quality Profiling

images

In this chapter we will perform some data quality profiling checks on the order fact table. Typically, we would perform data profiling on all the tables in the ODS that feed our data mart. As space is limited in this chapter, I will pick a simple example to illustrate the main tools that are provided with the SQL Server 2008 architecture.

Let's take a look at where we are first from an architectural perspective. Figure 10.1 below shows the completed architecture.

images

Figure 10.1 - Completed Cafe Magnifico Data Mart ...

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