Reasons Not to Denormalize With Repeating Groups - Teradata Database

Teradata Database Design

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
Product Category
Software

Reasons Not to Denormalize With Repeating Groups

The following items all mitigate the use of repeating groups:

  • Makes it difficult to detect which month an attribute corresponds to
  • Makes it impossible to compare periods other than months
  • Changing the number of columns requires both DDL and application modifications