Hello people. End to end testing dw functionality is problem we don't have satisfactory solution yet. We have daily dts packages feeding dw from production. After data are integrated some application specific data marts are refreshed and some summary data are sent back to production dbs. Because of huge amount of data and complex transformation and overall processes it is dificult to define efficient qa process for testing if information flow from production dbs trough dw and back to the production (and/or applications data mart) is correct. I would like to learn about experiance other people have with this.