Data Profiling Task - SQL Server 2008

Publicado em: 03 Julho 2010
no canal de: DBATAG

23,066

Full Detailed Article for "Data Profiling Task" is available at :

http://sqlserver-training.com/data-pr...

Follow us at more Updates at
-----------------------------------------
Website : http://sqlserver-training.com/
Twitter :   / dbatag
Facebook :   / dbatag
Linked In :   / dbatag
================================

Data Profiling is being supported by SQL Server 2008 for SQL Server data. You use the Data Profiling task to configure the profiles that you want to compute and then run the SSIS package that contains the task. The task creates results in XML format, which you can then review in the Data Profile Viewer.

Data profiling can help you to:
• Analyze and understand your source data better and more efficiently.
• Identify data quality problems before they are moved to the data warehouse

Information that is gathered during profiling may include:
• The percentage of null values.
• The distribution of values in the column.
• Column statistics for numeric columns.
• Regular expressions that match string columns.
• Validity of a relationship between columns.
• Candidate key columns.
• Functional dependencies between columns. For example, the strength of the dependency between the state and zip code fields.
• The inclusion of the set of values in one column in the set of values in another column.

How to Open Data Profile Viewer

To run the Data Profile Viewer, on the Start menu, click in the run box, type dataprofileviewer and then press ENTER.

Visit the following link for more details and SQL Server Tutorials
http://sqlserver-training.com/data-pr...

Nesta página do site você pode assistir ao vídeo on-line Data Profiling Task - SQL Server 2008 duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário DBATAG 03 Julho 2010, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 23,066 vezes e gostou 63 espectadores. Boa visualização!

54,509

1 mil