Having a testing plan ready in advance is always advisable as it also help the development steps to test it timely. Once data warehouse is ready and ETL transformation is in place get all the components and modules tested from testing team. Testing teams needs to be aware of Business process along with technical details of data warehouse. following are the areas where testing needs to be done before rolling out the data warehouse.
1. Test the data warehouse against reporting needs.
2. Test the ETL process for quality of data and its coverage in terms of available data sources.
3. Test the data warehouse against SQL queries to be written for reporting.
5. Test the data warehouse for performance loads.
6. Check the data warehouse for organizations data security norms and rules.
Did you enjoy this article? Please subscribe to Email or RSS to receive all the FREE updates!
Related posts: