15.00 - Reasons Not to Denormalize With Repeating Groups - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

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