Data Profiling
I am very pleased to see Data Profiling Task is going to be part of SQL2008. I have been requesting this task since SQL 2005 TAP programme when I was at Reuters.
You can read all about Data Profiling Task here.
Another feature I would like to see and have requested in the past is Dependancy Analysis Graphical Tool, which will tell me what would the impact on the whole project if I delete a column x from the ETL. In otherwords, which tables, views, stored procedures, packages, cubes and reports are affected by this change. I know there is an add-on available which allows us to do Dependancy Analysis. This was shipped as part of SQL Server 2005 Business Intelligence Metadata Samples Toolkit.
Does anyone agrees with me or not?
Thanks
Sutha