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 if you havent installed yet points Your database should meet these requirements: DimDate table has DateKey values ranging from to 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 points DimDate table should have WeekNumber int data type IsDayLightSavingToday boolean data type and EnglishMonthName varchar data type attributes points DimYear table should have TotalNumberofDay int data type attributes points DimProduct should contain ProductName varchar data type ProductVendorName varchar data type and IsProductDiscontinued Boolean data type points One FactYearlyIncomeStatement has foreign keys ProductKey and YearKey, and three fact measures YearlyTotalRevenue, YearlyTotalProductExpense, YearlyTotalProfit points One FactTransaction has foreign keys ProductKey and DateKey, and one fact measure TotalProductSold points
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
