PK

DimDate

DateKey

FullDate

EnglishDayName

EnglishMonthName

CalendarYear

Quarter

DayOfWeek

IsWeekend

int

date time

varchar(10)

varchar(10)

int

int

int

boolean

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!!/nAssignment 3 - ETL for Simple Dimension Tables

Summer 2023

It must be submitted through the

"Assignment 3 - 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. The

attachment name should follow the following convention:

BUSA532_ASSIGNMENT3_FIRSTNAME_LASTNAME.DTSX.

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 DateKey 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

(10 points).