Take the 2-minute tour ×
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.

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. –  FreshPhilOfSO Feb 28 '13 at 23:38
add comment

closed as not constructive by Mark Storey-Smith, dezso, ypercube, Marian, RolandoMySQLDBA Mar 7 '13 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 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, visit the help center for guidance.If this question can be reworded to fit the rules in the help center, please edit the question.

1 Answer

up vote 1 down vote accepted

DataCleaner is pretty good (spoken like Larry David)

http://datacleaner.org/

Integrates w Pentaho Data Integration (Kettle) too

share|improve this answer
add comment

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