Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Strategic Management

Authors: Richard Lynch , Oliver Barish Barish , Vinh Sum Chau , Charles Thornton , Karl S. R. Warner

10th Edition

1529672554, 978-1529672558

More Books

Students also viewed these General Management questions

Question

Discuss providing criticism with respect for the individual.

Answered: 1 week ago