You are designing a SQL Server Analysis Services (SSAS) cube based on a Microsoft Azure
SQL Database data warehouse.
You need to implement a degenerate dimension.
What should you do?
A.
Use the fact table as the data source for the dimension.
B.
Create snowflake dimension tables based on normalized views of the fact table in the
data source.
C.
Create a junk dimension table based on the fact table in the data source.
D.
Add a surrogate key to the fact table and use it as the degenerate dimension key.
The correct answer should be D. A degenerate dimension is stored in Fact Table and it’s a dimension key, a key without related dimension that provides grouping and business meaning
0
0
“A” is correct
In a data warehouse, a degenerate dimension is a dimension which is derived from the fact table and doesn’t have its own dimension table.
http://sql-bi-dev.blogspot.com/2010/05/creating-degenerated-dimension.html
0
0
I agree
0
0