Assignment 6 - ETL for Accumulating Snapshot Enterprise Data Warehouse Summer 2023 It must be submitted through the "Assignment 6 - ETL for Accumulating Snapshot Enterprise Data Warehouse" in Assignment Submission Folder in the D2L. It is important that you specify your name in the SQL Server Integration Service DTSX file. The attachment name should follow the following convention: BUSA532_ASSIGNMENT6_FIRSTNAME_LASTNAME.DTSX. Overview: We have learned to load data into periodic snapshot fact table in assignment 5. In assignment 6, your goal is to load data from OLTP database to create dimension and accumulating snapshot fact table using SSIS. Business scenario: Please install AdventureWorks database, read the AdventureWorks case study, and analyze the ERD OLTP schema before starting this assignment. The CEO of Adventure Work Inc. wants a data warehouse to keep track of order's lifecycle. The figure below shows tables of Adventure Work Inc.'s OLAP. Three fact metrics that he wants to have for his data warehouse: TotalOrderQuantity, TotalOrderDueQuantity, and TotalOrderShipQuantity. Create SSIS package solution that can perform ETL process to load data into OLAP database (10 points). Please note that DimCustomer does not need to handle Slowly Changing Dimension issues. DimDate PK DateKey int FullDate date AccumulatingFactOrderPerformance PK FactKey int DimCustomer FK OrderDateKey int PK CustomerKey int - FK DueDateKey int CustomerFirstName varchar(25) FK Ship DateKey int CustomerLastName varchar(25) FK CustomerKey int TotalOrdeQuantity int TotalOrderDueQuantity int TotalOrderShipQuantity int The following criteria will be used to grade the assignment: · Codes are run with detail comment, accurate, and answers are correct. ** ** *NOTE Please feel free to consult your instructor by email or phone, if you have questions or need assistance !!