Question: What are junk dimensions and degenerate dimensions and what is the importance of junk and degenerate dimensions in a data warehouse?
Chuck Kelley's Answer: Junk dimensions are dimensions that contain miscellaneous data (like flags and indicators) that do not fit in the base dimension table. Here is a link to Ralph Kimball and Margy Ross on junk dimensions. http://www.kimballgroup.com/html/designtipsPDF/DesignTips2003/KimballDT48DeClutter.pdf
Register or login for access to this item and much more
All Information Management content is archived after seven days.
Community members receive:
- All recent and archived articles
- Conference offers and updates
- A full menu of enewsletter options
- Web seminars, white papers, ebooks
Already have an account? Log In
Don't have an account? Register for Free Unlimited Access