Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 1 down vote favorite

Are there open source (or commercial) tools that can report data quality issues in a data warehouse using the Kimball star schema model? It doesn't have to be the silver bullet. I'm just looking for something to start with that can give basic details of data quality.

share|improve this question
2  
I suspect not. What determines the quality of a given piece of data? Ordinarily, you'd have an ETL process that transforms and loads to your DWH, ditching bad data as it goes. – Phil Feb 28 at 23:38

closed as not constructive by Mark Storey-Smith, dezso, ypercube, Marian, RolandoMySQLDBA Mar 7 at 6:05

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or specific expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, see the FAQ for guidance.

1 Answer

up vote 1 down vote

DataCleaner is pretty good (spoken like Larry David)

http://datacleaner.org/

Integrates w Pentaho Data Integration (Kettle) too

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.