In a typical star schema, each dimension record is related to thousands of _____ records.
A) attribute
B) fact
C) key
D) primary

Question

Quizplus · Accepted Answer

In a typical star schema, each dimension record is related to thousands of fact records. Fact tables contain measurements, metrics or facts about a business process, while the dimension table contains attributes related to the facts. The relationship between the dimension and fact tables is many-to-one. Therefore, for a particular dimension, there are multiple rows or records in the fact table.

In a Typical Star Schema, Each Dimension Record Is Related