Multiple choice technology platforms and products

Centipede fact table means:

  1. Fact table with no dimensions

  2. Factless fact table

  3. Fact table with two or three dimensions

  4. Fact table with to many dimensions
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

A centipede fact table refers to a fact table with an excessive number of dimensions (often 15+), which makes it difficult to manage and query efficiently. This pattern is considered an anti-pattern in dimensional modeling because it violates the principle of keeping fact tables focused on specific business processes. The name 'centipede' metaphorically describes the table having 'too many legs' (dimensions).

Keep practicing — related questions