CHAPTER 10

image

Data Profiling

Every person whose work involves data ingestion and consolidation wants to know exactly what constitutes the source data that they are using. While this does not mean knowing every morsel of data in every table, it can and should mean having a high-level view of what is (and equally important—what is not) in a column of data. This knowledge can often be a valuable first step in deciding on the validity of a data source, and even in choosing whether or not to proceed with an ETL process. Indeed, since introduction of the Data Profiling task in SSIS 2008, the importance of data profiling seems to have been recognized by ...

Get SQL Server 2012 Data Integration Recipes: Solutions for Integration Services and Other ETL Tools now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.