Home » Interview » Technology

What are fact tables and dimension tables?

Correct Answer: Business facts or measures and foreign keys are persisted in fact tables which are referred as candidate keys in dimension tables Additive values are usually provided by the fact tables which acts as independent variables by which dimensional attributes are analyzed Attributes that are used to constrain and group data for performing data warehousing queries are persisted in the dimension tables

← Previous Question Next Question→

Discussion & Comments

No comments yet. Be the first to comment!
Join Discussion