Large corporations spend millions of dollars every year on the development and maintenance of corporate data warehouses. The systems are very complex and include components built in house, off-the-shelf solutions from third parties as well as jointly developed and customized work by external and internal teams. Typically, the component designers concentrate on meeting business and functional requirements and do not take into account production environment performance constraints. This often leads to costly rework and deadlines slippage after the deliverables are rolled out into production due to operational inefficiencies. This article presents an approach developed at Motorola to predict extraction, transformation and loading (ETL) performance at early stages of the data warehouse (DW) development cycle.
Correlation between ETL Performance and DW Software Design
All Information Management articles are archived after 7 days. REGISTER NOW for unlimited access to all recently archived articles, as well as thousands of searchable stories. Registered Members also gain access to:
- Full access to information-management.com including all searchable archived content
- Exclusive E-Newsletters delivering the latest headlines to your inbox
- Access to White Papers, Web Seminars, and Blog Discussions
- Discounts to upcoming conferences & events
- Uninterrupted access to all sponsored content, and MORE!