Research the concepts and technology of data ETL (Extraction, Transformation & Loading) and document the process from start to finish using Microsoft SSIS (SQL Server Integration Services) as the basis of your study.
Learning Outcome(s) Being Assessed:
1. Describe the operation of a data warehouse in support of business intelligence.
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