SQL - Database Design and Normalization
Which SQL JOIN type is typically used to connect fact and dimension tables in a star schema?
Which SQL JOIN type is typically used to connect fact and dimension tables in a star schema?
easy📝 Syntax Q12 of 15
Step-by-Step Solution
Solution:
Step 1: Understand fact-dimension relationship
Fact tables usually have matching keys in dimension tables.Step 2: Choose JOIN type for matching rows
INNER JOIN returns only matching rows, ideal for star schema queries.Final Answer:
INNER JOIN -> Option AQuick Check:
Fact and dimension use INNER JOIN [OK]
Quick Trick: Use INNER JOIN to link matching keys [OK]
Common Mistakes:
- Using CROSS JOIN which multiplies rows
- Using FULL OUTER JOIN causing unnecessary nulls
- Using LEFT JOIN when INNER JOIN suffices
Master "Database Design and Normalization" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes