ETL development and testing
I am inspectingthe BI delivery methods in my company looking for new efficient ways. We are working in the traditional "water flow" methodswere requierments being translated by development to ETL packages, testers translate it there way to some SQL script and compare both results of the SQL scripts and the package.
Seems to me that instead of writtng the same solution twice it is better to have one process of close cooperatino between development and testing using the same platform, methods and tool.
I am looking for a new methology, examples of similiar implementation in other companies.
Thanks for your help



