Multiple choice technology

The term shrunken dimension is associated with

  1. Aggregation

  2. Filtering

  3. Extraction

  4. Loading
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Shrunken dimensions are created through the aggregation process in dimensional modeling. When a dimension table is summarized or aggregated at a higher level (such as aggregating from daily to monthly), it becomes a shrunken dimension. This technique reduces dimension size and improves query performance for summary-level analysis.

Keep practicing — related questions