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 D$2$L$,$ then create SSIS package solution that can perform ETL process to load data into your Date dimension

table $(10$ points$).$

The following criteria will be used to grade the assignment:

Codes are run with detail comment, accurate, and answers are correct.

Excel DateKeyAW.cvs

DateKey

$20110531$

$20110601$

$20110602$

$20110603$

$20110604$

$20110605$

$20110606$

$20110607$

$20110608$

$20110609$

$20110610$

$20110611$

$20110612$

$20110613$

$20110614$

$20110615$

$20110616$

$20110617$

$20110618$

$20110619$

$20110620$

$20110621$

$20110622$

$20110623$

$20110624$

$20110625$

$20110626$

$20110627$

$20110628$

$20110629$

$20110630$

$20110701$

$20110702$

$20110703$

$20110704$

$20110705$

$20110706$

$20110707$

$20110708$

$20110709$

$20110710$

$20110711$

$20110712$

$20110713$

$20110714$

$20110715$

$20110716$

$20110717$

$20110718$

$20110719$

$20110720$

$20110721$

$20110722$

$20110723$

$20110724$

$20110725$

$20110726$

$20110727$

$20110728$

$20110729$

$20110730$

$20110731$

$20110801$

$20110802$

$20110803$

$20110804$

$20110805$

$20110806$

$20110807$

$20110808$

$20110809$

$20110810$

$20110811$

$20110812$

$20110813$

$20110814$

$20110815$

$20110816$

$20110817$

$20110818$

$20110819$

$20110820$

$20110821$

$20110822$

$20110823$

$20110824$

$20110825$

$20110826$

$20110827$

$20110828$

$20110829$

$20110830$

$20110831$

$20110901$

$20110902$

$20110903$

$20110904$

$20110905$

$20110906$

$20110907$

$20110908$

$20110909$

$20110910$

$20110911$

$20110912$

$20110913$

$20110914$

$20110915$

$20110916$

$20110917$

$20110918$

$20110919$

$20110920$

$20110921$

$20110922$

$20110923$

$20110924$

$20110925$

$20110926$

$20110927$

$20110928$

$20110929$

$20110930$

$20111001$

$20111002$

$20111003$

$20111004$

$20111005$

$20111006$

$20111007$

$20111008$

$20111009$

$20111010$

$20111011$

$20111012$

$20111013$

$20111014$

$20111015$

$20111016$

$20111017$

$20111018$

$20111019$

$20111020$

$20111021$

$20111022$

$20111023$

$20111024$

$20111025$

$20111026$

$20111027$

$20111028$

$20111029$

$20111030$

$20111031$

$20111101$

$20111102$

$20111103$

$20111104$

$20111105$

$20111106$

$20111107$

$20111108$

$20111109$

$20111110$

$20111111$

$20111112$

$2< Step by Step Solution There are 3 Steps involved in it 1 Expert Approved Answer Step: 1 Unlock Question Has Been Solved by an Expert! Get step-by-step solutions from verified subject matter experts Step: 2 Unlock Step: 3 Unlock Students Have Also Explored These Related Programming Questions! Q: 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... Q: 1. What directly accesses a database? A. Accounting system users B. DBMS C. Finance system users D. All of the above 2.Whichofthefollowingisaformofstatisticalanalysis?A.Forecasting... Q: Can you please answer this questions below QUESTION 1 The key to any successful report is clarity, ____, completeness, and correctness. a. actuality b. longevity c. brevity 2 points QUESTION 2 A is a... Q: Which kind of chart is described as an enhanced variant of a scatter plot? * heat map bullet O pie chart bubble chart Because the customer experience is critical, all customer issues need to be... Q: A data warehouse is which of the following? Can be updated by end users. Contains numerous naming conventions and formats. Organized around important subject areas. Contains only current data. An... Q: Data Warehousing Failures Eight studies of data warehousing failures are presented. They were written based on interviews with people who were associated with the projects. The extent of the failure... Q: Data Warehousing Failures Eight studies of data warehousing failures are presented. They were written based on interviews with people who were associated with the projects. The extent of the failure... Q: Data Warehousing Failures Eight studies of data warehousing failures are presented. They were written based on interviews with people who were associated with the projects. The extent of the failure... Q: Data Warehousing Failures Eight studies of data warehousing failures are presented. They were written based on interviews with people who were associated with the projects. The extent of the failure... Q: INTERNATIONAL REVIEW OF L AW C OMPUTERS & TECHNOLOGY , VOLUME 11, N UMBER 2, P AGES 251-261, 1997 The Data Mart: A New Approach to Data Warehousing PAM ELA PIPE Introduction Vendors have recently... Q: (Computer exercise) Researchers measured the diameters of 20 trees in a central Amazon rain forest and used 14C-dating to determine the ages of these trees. The data are given in the following... Q: Your broker has offered to sell you a bond with a maturity of 4 years, a face value of $100, and that pays annual coupons with a coupon rate of 4%,. The current price of the bond is $98. What is the... Q: It is usually most helpful to recognize materials price variance at the time of purchase of materials. issuance of materials. completion of the finished product. responses b and c are equally correct. Q: Graph the line that passes through the point 4 5 with a slope of Give an equation for this line What is the y intercept for this line Y use exact numbers no decimals give your answer as a point use... Previous Question Next Question Recommended Textbook More Books Mastering Your Iphone 11 Pro Max Iphone 11 Pro Max User Guide For Beginners New Iphone 11 Pro Max Users And Seniors Authors: Tech Reviewer 1st Edition 1694849554, 978-1694849557 Ask a Question and Get Instant Help! Study Help Services Sitemap Fun Definitions Become Tutor Used Textbooks Study Help Categories Recent Questions Expert Questions Campus Wear Sell Your Books Company Info Security Copyrights Privacy Policy Terms & Conditions SolutionInn Fee Scholarship Online Quiz Give Feedback, Get Rewards Get In Touch About Us Contact Us Career Jobs FAQ Student Discount Campus Ambassador Secure Payment Download Our App © 2026 SolutionInn. All Rights Reserved $