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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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.

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 '13 at 23:38
up vote 1 down vote accepted

DataCleaner is pretty good (spoken like Larry David)

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.