Question: For each dimension table in the diagram you created, identify each column in the fact table that relates the fact table to the dimension table.
- For each dimension table in the diagram you created, identify each column in the fact table that relates the fact table to the dimension table. Note: Be sure to include multiple date columns.
- What does a row in the factInternetSales table represent to the business? Explain in your own words.
Dim Product ProductKey ProductAlternatekey ProductSubcategoryKey Weight Unit MeasureCode SizeUnitMeasureCode English ProductName Spanish ProductName FrenchProductName StandardCost Finished GoodsFlag Color SafetyStockLevel ReorderPoint ListPrice Size SizeRange Weight DaysToManufacture ProductLine Dealer Price Class Style FactInternetSales * OrderDateKey DueDatekey ShipDatekey Customerkey PromotionKey Currencykey Sales Territory Key SalesOrderNumber SalesOrderLine Number Revision Number OrderQuantity UnitPrice ExtendedAmount UnitPrice DiscountPct DiscountAmount Product StandardCost TotalProductCost SalesAmount TaxAmt Freight Carrier Tracking Number CustomerPONumber Order Date DimCustomer Customerkey GeographyKey CustomerAlternatekey Title FirstName MiddleName LastName NameStyle Birth Date MaritalStatus Suffix Gender Email Address YearlyIncome TotalChildren NumberChildrenAtHome English Education Spanish Education FrenchEducation English Occupation Spanish Occupation DimDate * DateKey FullDate Alternatekey DayNumberOfWeek English DayNameOfWeek SpanishDayNameOfWeek FrenchDayNameOfWeek DayNumberOfMonth DayNumberOfYear WeekNumberOfYear English MonthName SpanishMonthName French MonthName
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
