And are there any tools for Data Warehouse performance testing?
In my experience I haven't observed any specific tool that too exclusively for Data warehousing performance testing. But where as ETL tools will allow us to progress with performance testing while coding is in progress.
For each of ETL tools, they do have their own best practices for Data Warehouse performance testing.
For
Informatica ETL Tool, there's a complete document for performance Testing and Tuning. Hope this all gives you a clarity.
