a) Below is a join query of a SQL against a database. Based on this query,...

 

Transcribed Image Text:

a) Below is a join query of a SQL against a database. Based on this query, identify Dimension, Facts and Data Hierarchies. SELECT b) Based on the below query, identify if the DW uses Star Schema versus Snow-Flake Schema. c) In your own words, write down any 3 differences between Star Schema and Snow-Flaked schema. P.Brand, S. Country AS Countries, SUM (F.Units_Sold) FROM Fact Sales F INNER JOIN Dim_Date D ON F.Date Id ON F.Store Id INNER JOIN Dim_Store S INNER JOIN Dim_Product P ON F. Product Id WHERE D. YEAR= 1997 AND P.Product Category 'tv' GROUP BY P.Brand, S. Country D. Id S. Id P. Id a) Below is a join query of a SQL against a database. Based on this query, identify Dimension, Facts and Data Hierarchies. SELECT b) Based on the below query, identify if the DW uses Star Schema versus Snow-Flake Schema. c) In your own words, write down any 3 differences between Star Schema and Snow-Flaked schema. P.Brand, S. Country AS Countries, SUM (F.Units_Sold) FROM Fact Sales F INNER JOIN Dim_Date D ON F.Date Id ON F.Store Id INNER JOIN Dim_Store S INNER JOIN Dim_Product P ON F. Product Id WHERE D. YEAR= 1997 AND P.Product Category 'tv' GROUP BY P.Brand, S. Country D. Id S. Id P. Id

Answer rating: 100% (QA)

a In this SQL query Dimension Dim Date D Dim Store S Dim Product P Facts Fact Sales F Data Hierarchi... View the full answer