Problem solve Get help with specific problems with your technologies, process and projects.

Requirements questionnaire template

Can you please help me find a requirements questionaire template for a data warehouse project? I have gone through the 'Net extensively, and I've come up with a questionnaire. This questionnaire covers various stages of the warehouse development from functionality, transactions, data sources, ETL process, Data cleansing, Analytical Processing (OLAP), Business Rules, Client participation, Roles and Responsibilities and many more aspects. However I would really appreciate any more information that I can gather on this aspect. The utopian solution would be if you could give me a ready-made questionnaire for requirements gathering.

I'd love to give you a ready-made, one-size-fits-all questionnaire. The fact is, there really is no such thing. You are well on the way of developing a comprehensive approach to gathering requirements. I encourage you to not overlook the technology architecture, infrastructure and operational procedures. These aspects all have requirements that need to be flushed out. I also firmly believe that understanding the business process model as well as enterprise data model is critical to fully understanding the functional requirements of your data warehouse. Understanding the process model drives to understanding the corporate & functional goals, key performance metrics and business information needs. These drive towards understanding what your information access layer needs to support.

For More Information

Dig Deeper on Oracle DBA jobs, training and certification