Question { IBM, 35937 }

Please explain in detail with example about
1.Confirmed Dimension.
2.Junk Dimension.
3.Degenerated Dimension.
4.Slowly changing Dimensions

Answer

1.A dimension table which can be shared by multiple fact
tables is know as confirmed dimension.

2.A junk diemesion with type discriptive data boolean , flag
datatype can't be used to discribed the key performance
integrator are know as junk dimension for
exple:productdiscription,address,zipcode,phone number

if a table contains the values which are neither dimension nor
measure is called degenerate dimensions for
exple:invoice-id,empno