COMP6048: Innovations in Software Development- Data WareHouse Assignment

Internal Code: MAS1929

Data WareHouse Assignment:

Task: Details of Task: ETL is an important process in the construction of Data WareHouse solutions. It consists of the following three primary phases, you must research each as well as the more specific steps contained within: 1. Extracting Data A. From one or more external data sources. 2. Transforming Data A. Ensure consistency and satisfy business requirements. 3. Loading Data A. To the resultant Data WareHouse. Microsoft SSIS provides a collection of tools to support ETL including: 1. Data Flow Engine. 2. Scripting Environment. 3. Data Profiler. You must discuss the various tools that SSIS provides and relate them to the phases within ETL. You should also provide suitable examples from case studies (such as AdventureWorks & AdventureWorksDW) to reinforce your discussions.