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.