O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

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

Profiling table statistics: Data Profiling Task

Data Profiling is an increasingly used task, and as such, it's necessary to understand the data extracted from sources in detail and also to reduce problems with the data's quality during the data integration process. In an ETL scenario, this data profiling should be done before the ETL process accesses the source system directly, or if that's not possible, then after the Extract stage where there usually isn't any transformation on data applied. If the data profile is not known, the risk of problems during later stages (Transform and Load) will significantly increase.

When source data is profiled using this task, the output could be a column null ratio, column lengths and values distribution, column ...

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