• Marketplace

  • Find Data Modeling Basics products & services on
    DM Review Marketplace

• Channel Resources

  Articles from this Site

  • A Statistical Stocking Stuffer for the Holidays

  • What are your views on the advantages and/or disadvantages ETL tools and data modeling versus code?

  • New Interfaces Integrated into MEGA International Modeling Software

  • Which would be a better choice of classes for career growth in data warehousing - ETL architecture or dimensional modeling?

  • CA ERwin Data Modeler Designs Tool to Integrate with Microsoft Visual Studio 2005 Team Edition for Database Professionals

  • More Articles from this Site

  White Papers

  • Best Practices: Eight Tips for Improving Your Professional Services Business

  • Metadata Management for Enterprise Applications

  • UML for C#

  • PHP Code Design

  • Domain-Specific Modeling: 10x Faster than UML

  • More White Papers

  Web Seminars

  • Modeling Unstructured Data

  • Creative Strategies for Achieving 24/7 Uptime

  • More Web Seminars

  Books

  • Data Mining Cookbook: Modeling Data for Marketing, Risk and Customer Relationship Management

  • Data Modeler's Workbench: Tools and Techniques for Analysis and Design

  • The Data Modeling Handbook: A Best-Practice Approach to Building Quality Data Models

  • Data Mining Using SAS Applications

  • Data Mining: Concepts, Models, Methods and Algorithms

  • More Books

FREE DM Review Site Registration!

Sign-up today and access DM Review on the Web! Your FREE registration entitles you to: FREE email newsletters FREE access to all DM Review content FREE access to web seminars, resource portals, our white paper library and more!     Publisher reserves the right to serve qualified requesters only.

What is a junk dimension? Is that similar to a conformed dimension?

• Chuck Kelley
• DM Review Online, June 1, 2007

Question: What is a junk dimension? Is that similar to a conformed dimension?

Chuck Kelley's Answer: Here is a discussion on DMReview.com on junk dimensions (http://www.dmreview.com/article_sub.cfm?articleId=1027074). Should that be a conformed dimension? I would say "Yes" if it was used in more than one data mart. But then, that is basically the definition of a conformed dimension.

Chuck Kelley is an internationally known expert in database and data warehousing technology. He has 30 years of experience in designing and implementing operational/production systems and data warehouses. Kelley has worked in some facet of the design and implementation phase of more than 50 data warehouses and data marts. He also teaches seminars, co-authored four books on data warehousing and has been published in many trade magazines on database technology, data warehousing and enterprise data strategies. He can be contacted at chuckkelley@usa.net.

For more information on related topics, visit the following channels:

• Data Modeling