Universitat Oberta de Catalunya
Data Warehouse (DW) design is based on a set of requirements expressed as Service Level Agreements (SLAs) and Business Level Objects (BLOs). Populating a DW system from a set of information sources is realized with Extract-Transform-Load (ETL) processes based on SLAs and BLOs. The entire task is complex, time consuming, and hard to be performed manually. In this paper, the authors present their approach to the requirement-driven creation of ETL designs. Each requirement is considered separately and a respective ETL design is produced.