SSIS Packages for ETL

Having declared revisions to create new structures in the data warehouse database, we can extend the ETL process to populate the new structures. Aside from moving data from one place to another, ETL processes are an opportunity perform calculations. This can reduce the load on the application by moving the processing time from the time at which calculated data is accessed to the ETL process.