install AdventureWorks database, read the AdventureWorks case study

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

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 (8 points), and submit the mapping document in Word file in D2L (2 points).

 DimDate

PK

DateKey

int

FullDate

date time

EnglishDayName

varchar(10)

EnglishMonthName

varchar(10)

CalendarYear

int

Quarter

int

DayOfWeek

int

IsHoliday

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

 

Attachments:

Related Questions

. Introgramming & Unix Fall 2018, CRN 44882, Oakland University Homework Assignment 6 - Using Arrays and Functions in C

DescriptionIn this final assignment, the students will demonstrate their ability to apply two ma

. The standard path finding involves finding the (shortest) path from an origin to a destination, typically on a map. This is an

Path finding involves finding a path from A to B. Typically we want the path to have certain properties,such as being the shortest or to avoid going t

. Develop a program to emulate a purchase transaction at a retail store. This program will have two classes, a LineItem class and a Transaction class. The LineItem class will represent an individual

Develop a program to emulate a purchase transaction at a retail store. Thisprogram will have two classes, a LineItem class and a Transaction class. Th

. SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 1 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of

. Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of