Transformation
Traditional Transformation Process
- Use the warehouse for ETL
- Co-ordinate many environments
- Co-ordinate multiple teams
- High project management load
- High documentation load
- Target environment is not independent of ETL stream
- Transformation processes occur at all points
- Difficult to plan
- Hard to code manually
- Very hard to change or rework
- Single stream approach
- Limits transformation models
- Requires many iterations