Events

A goal of this project is to minimize process time and the amount of data transferred. It provides an efficient ETL workflow and dataflow to get data populated in the staging database so that further ETL can populate an ODS, dimensional model, and finally an Analysis Services cube. The design needs to follow current data warehousing standards for efficient reporting and maintenance. The ETL processing will run as many tasks in parallel as possible and should run as quickly as possible to ensure that further ETL and cube processing tasks have time to finish.