Use Adventureworks2014 or later database

1. For the Product dimension:

1. List the row(s) from the Product dimension table that hold information about product HL-U509-R. Show the following columns: ProductKey, ProductAlternateKey, EnglishProductName, StandardCost, ListPrice, Status.

Hint: HL-U509-R is stored in the ProductAlternateKey field.

2. List the row(s) for the same product in the operational database. Remember, the operational database is AdventureWorks2014 (or later). Include similar descriptive columns and primary key values.

Hint: HL-U509-R is stored in the ProductNumber field.

3. Could there be multiple rows in the Product dimension table for a given product in the operational database? If yes, how does that arise? If no, why should that not happen?

2. In dimensional modeling terminology, a type 1 slowly changing dimension is one where original values for data are overwritten by new values when a change occurs. For example, if a customers last name changes, no record of the former last name is maintained in the database. Only the new last name is available. A type 2 slowly changing dimension is one where a new row is added to the dimension to record the changed values. In a type 2 slowly changing dimension table, multiple rows may pertain to one entity such as a store or product.

Is the Product dimension a slowly changing dimension? If yes, is it a Type 1 or Type 2 slowly changing dimension? Explain your answer (yes or no).

Type 2. A product can have multiple records based on if it is current of discontinued.

1 x IX Properties [Col] ProductAlternatekey Object Explorer Connect XIY the A Databases + System Databases + Database Snapshots + AdventureWorks2017 Adventure Works DW2017 + Database Diagrams A Tables + System Tables + File Tables + External Tables Graph Tables + dbo.AdventureWorks DWBuildVersion + 6 dbo.DatabaseLog + dbo.DimAccount + dbo.DimCurrency + 5 dbo.DimCustomer + dbo.DimDate + dbo.DimDepartment Group + 5 dbo.DimEmployee + dbo.DimGeography + dbo.DimOrganization + 1 dbo.DimProduct + 6 dbo.DimProductCategory + dbo.DimProductSubcategory + dbo.DimPromotion + 6 dbo.DimReseller + dbo.DimSalesReason + 1 dbo.DimSalesTerritory + 5 dbo.DimScenario + dbo.FactAdditionallnternational ProductDes + dbo.FactCallCenter + 2 dbo.FactCurrency Rate + dbo.FactFinance + dbo.FactInternet Sales + dbo.FactInternetSales Reason + dbo.FactProductinventory + i dbo.FactResellerSales + Edbo.FactSalesQuota + dbo.FactSurvey Response + dbo.NewFactCurrency Rate + dbo.ProspectiveBuyer Views DESKTOP-UAFVBHG...2017 - Diagram_1* + X DimProduct ProductKey ProductAlternatekey ProductSubcategoryKey WeightUnitMeasureCode SizeUnitMeasureCode English ProductName Spanish ProductName FrenchProductName Standard Cost Finished GoodsFlag Color SafetyStockLevel ReorderPoint ListPrice Size SizeRange Weight DaysToManufacture ProductLine Dealer Price Class Style ModelName LargePhoto EnglishDescription French Description Chinese Description ArabicDescription HebrewDescription ThaiDescription GermanDescription Japanese Description Turkish Description StartDate EndDate Status 9 (General) (Name) ProductAlternatekey Allow Nulls Yes Data Type nvarchar Default Value or Bi Length 25 Database Designer Collation . Computed Column Condensed Data Ty nvarchar(25) Description Deterministic Yes DTS-published No + Full-text Specificati No Has Non-SQL Servi No Identity Specificati No Indexable Yes Is Columnset No Is Sparse No Merge-published No Not For Replicatior No Replicated RowGuid Size 50 Collation 1 x IX Properties [Col] ProductAlternatekey Object Explorer Connect XIY the A Databases + System Databases + Database Snapshots + AdventureWorks2017 Adventure Works DW2017 + Database Diagrams A Tables + System Tables + File Tables + External Tables Graph Tables + dbo.AdventureWorks DWBuildVersion + 6 dbo.DatabaseLog + dbo.DimAccount + dbo.DimCurrency + 5 dbo.DimCustomer + dbo.DimDate + dbo.DimDepartment Group + 5 dbo.DimEmployee + dbo.DimGeography + dbo.DimOrganization + 1 dbo.DimProduct + 6 dbo.DimProductCategory + dbo.DimProductSubcategory + dbo.DimPromotion + 6 dbo.DimReseller + dbo.DimSalesReason + 1 dbo.DimSalesTerritory + 5 dbo.DimScenario + dbo.FactAdditionallnternational ProductDes + dbo.FactCallCenter + 2 dbo.FactCurrency Rate + dbo.FactFinance + dbo.FactInternet Sales + dbo.FactInternetSales Reason + dbo.FactProductinventory + i dbo.FactResellerSales + Edbo.FactSalesQuota + dbo.FactSurvey Response + dbo.NewFactCurrency Rate + dbo.ProspectiveBuyer Views DESKTOP-UAFVBHG...2017 - Diagram_1* + X DimProduct ProductKey ProductAlternatekey ProductSubcategoryKey WeightUnitMeasureCode SizeUnitMeasureCode English ProductName Spanish ProductName FrenchProductName Standard Cost Finished GoodsFlag Color SafetyStockLevel ReorderPoint ListPrice Size SizeRange Weight DaysToManufacture ProductLine Dealer Price Class Style ModelName LargePhoto EnglishDescription French Description Chinese Description ArabicDescription HebrewDescription ThaiDescription GermanDescription Japanese Description Turkish Description StartDate EndDate Status 9 (General) (Name) ProductAlternatekey Allow Nulls Yes Data Type nvarchar Default Value or Bi Length 25 Database Designer Collation . Computed Column Condensed Data Ty nvarchar(25) Description Deterministic Yes DTS-published No + Full-text Specificati No Has Non-SQL Servi No Identity Specificati No Indexable Yes Is Columnset No Is Sparse No Merge-published No Not For Replicatior No Replicated RowGuid Size 50 Collation