Since dealing with data integrity issues is very important before rolling out a productive use BI tool, I would like to see what others have done to address integrity issues, the approach in dealing with integrity issues etc.
In our ERP system there are known integrity issues, and there are parts in the ERP that have integrity issues that we don't know of until we do further analysis. Instead of us loading all the data from our ERP system to our data warehouse, we would like to address and fix these integrity issues before doing a final load. We are still in the development process of BI/DW implementation and want to know what kind of exercises, approaches, documentation etc. that others have done in the past that work well for them or any other tips that you can give me that will help me out.