Wednesday, April 30, 2014

SSIS Interview : Data Profiling Task

Data profiling is the process of analyzing the source data to better understand what condition the data
is in, in terms of cleanliness, patterns, number of nulls, and so on. In fact, you probably have done
data profiling before with scripts and spreadsheets, but perhaps you didn ’ t realize that it was called data profiling The output of the Data Profiling Task will be used to help you in your development and design of the ETL and dimensional structures in your solution. Periodically, you may want to re - run the Data Profile Task to see how the data has changed, but the package you develop will not include the task in the overall recurring ETL process.

No comments:

Post a Comment