What are the business needs ETL needs to think of

When it comes to what the ETL needs to provide, it boils down to the information the people in decision making roles need in order to make informed business decisions.

But the business needs are not set in stone. As such it is necessary to constantly reassess business needs and adjust the deliverables as necessary.

The only way to understand the business needs and how they change is to keep an open dialog with the end users.

References

• The Data Warehouse ETL Toolkit pg 4