Question: Use Adventure Work OLTP s schema to build a data warehouse consisting of two data marts. ( You can find instructions to install the database

Use Adventure Work OLTPs schema to build a data warehouse consisting of two data marts. (You can find instructions to install the database in Topic 2 if you havent installed yet).(100 points). Your database should meet these requirements: DimDate table has DateKey values ranging from 20100304 to 20140602(YYYYMMDD integer data type). If you use Flat File or Excel Data Source to import date key data, include the data source file in the submission also (5 points). DimDate table should have WeekNumber (int data type), IsDayLightSavingToday (boolean data type), and EnglishMonthName (varchar data type) attributes (15 points). DimYear table should have TotalNumberofDay (int data type) attributes (10 points). DimProduct should contain ProductName (varchar data type), ProductVendorName (varchar data type), and IsProductDiscontinued (Boolean data type)(20 points). One FactYearlyIncomeStatement has 2 foreign keys ProductKey and YearKey, and three fact measures - YearlyTotalRevenue, YearlyTotalProductExpense, YearlyTotalProfit (25 points). One FactTransaction has 2 foreign keys ProductKey and DateKey, and one fact measure TotalProductSold (25 points)
Use Adventure Work OLTP s schema to build a data

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
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!