In this Design Tip, we return to a fundamental concept that perplexes numerous dimensional modelers: text facts (also referred to as fact indicators, attributes, details or notes). Some of you may be rightfully saying that text facts are a dimensional modeling oxymoron. However, we frequently field questions from clients and students about indicator, type or comment fields that […]

Periodic check-ups will help you avoid letting business intelligence and data warehousing problems spin out of control. It’s human nature to resist visiting a doctor for periodic check-ups. Generally, we’d prefer to avoid being poked and prodded, having our vital signs taken, and then being told that we need to quit smoking, exercise more, or […]