EssayproSolutions

Use Adventureworks2014 Later Database Product Dimension List Row S Product Dimension Table Q43827726

Use Adventureworks2014 or later database

1. For the Product dimension:

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

Hint: HL-U509-R isstored in the ProductAlternateKey field.

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

Hint: HL-U509-R is stored in theProductNumber field.

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

2. In dimensional modeling terminology, a type 1 slowly changingdimension is one where original values for data are overwritten bynew values when a change occurs. For example, if a customer’s lastname changes, no record of the former last name is maintained inthe database. Only the new last name is available. A type 2 slowlychanging dimension is one where a new row is added to the dimensionto record the changed values. In a type 2 slowly changing dimensiontable, multiple rows may pertain to one entity such as a store orproduct.

Is the Product dimension a slowly changing dimension? If yes, isit a Type 1 or Type 2 slowly changing dimension? Explain youranswer (yes or no).

Type 2. A product can have multiple records based on if it iscurrent 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 <database default> . 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 Show transcribed image text 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

Expert Answer

Answer to Use Adventureworks2014 or later database For the Product dimension: List the row(s) from the Product dimension table th…