Multiple choice technology platforms and products

In dimensional model which table is loaded first

  1. fact table

  2. dimensional table

  3. both

  4. none
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Dimension tables must be loaded first because fact tables contain foreign keys that reference dimension tables. Loading dimensions before facts ensures referential integrity - you can't reference a dimension record that doesn't exist yet.

Keep practicing — related questions