Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sarblota
Starting Member
8 Posts |
 Posted - 2010-09-06 : 04:35:14
|
| HiI wonder if anyone knows of a decent tool set/code that handles data profiling on a sql server 2005 db?We have a warehouse that we need to apply monthly rules to so that the business can get an idea on data quality.For instance, we would want to apply simple logic rules to columns such 'Number of customers whose date of birth is null', or the age is over 120 etc.Furthermore I'd want the tool to be able to pick up outliers within a set of data.For reporting, I'd want to be able to see the errors either increasing/decreasing over time.I've conceptually started writing a meta rule set db that holds the 'rules' so that they can be constructed and executed on the fly.To prevent reinventing the wheel has anyone done this sort of thing before and willing to share code/ideas?cheerscheersSarb Lota |
|
|
|
|
|
Data Profiling Tools - SQL Server 2005