I need to do this assignment about Innovations in Software Development which is need to do and how we can use this software..1. Describe the operation of a data warehouse, in support of business intelligence.
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.
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:
• Extracting Data
o From one or more external data sources.
• Transforming Data
o Ensure consistency and satisfy business requirements.
• Loading Data
o To the resultant Data WareHouse.Assessment criteria
Must be have this quality below...
ETL Research & SSIS Study.