Problem: In software engineering, the discipline that studies the process people use to develop an information system is called the system development life cycle (SDLC) or the system development methodology. There are two main variants: waterfall and iterative. The waterfall methodology is also known as the sequential methodology. The iterative methodology is also known as the spiral or incremental methodology. The waterfall methodology is one of the oldest methodologies (it has been around for about 30 years) and is widely used by many organizations to build their systems, including their data warehouse systems. The iterative methodology is very different from waterfall. It is not as widely used as waterfall, but it gives good benefits if used correctly. Some people prefer waterfall and some people prefer iterative.
So based on your personal experience in system implementation, which methodology do you prefer when implementing a data warehousing project? Describe any advantages and disadvantages, or experiences, suggestions you have for a specific business use case.