ETL for Simple Dimension Table, SQL Server Integration Service & AdventureWorks Case Study - IT Assignment Help

Assignment Task

ETL for Simple Dimension Tables

It must be through the “Assignment 5–ETL for Simple Dimension Tables” in Assignment Submission Folder provided in the D2L. It is important that you specify your name in the SQL Server Integration Service DTSX file and Word document. The attachment name should follow the following convention:

 ASSIGNMENT_FIRSTNAME_LASTNAME.DTSX.

 ASSIGNMENT_FIRSTNAME_LASTNAME.DOCX.

Overview:

Now that we have learned to create dimensional model for enterprise data warehouse. The next phrase is ETL process that we are going to load our data from OLTP database to our OLAP database. In this assignment, your goal is to load data from Date Key CSV file into your Date dimension table in OLAP by 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 AdventureWorks wants a data warehouse to keep track of sales performance. The figure below shows the date dimension table of AdventureWorks’s OLAP. Import CSV file from D2L, then create SSIS package solution that can perform ETL process to load data into your Date dimension table and submit the mapping document in Word file in D2L.

This IT Assignment has been solved by our IT Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment Experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.