Facts and Dimensions Flashcards
In a dimensional data model the core tables are…
facts and dimensions
A row in a fact table corresponds to…
some significant, measurable event.
Ex: ordering a medication, posting a charge transaction
A row in a dimension table represents…
a concrete entity that provides context for some event in a fact table.
Ex: Patient, Pharmacy, or Billing Provider
A fact table contains relevant metrics and lookup columns. Another term for a lookup column is…
foreign key
In Caboodle all fact and dimension tables use a ___________ as their primary key.
surrogate key
Aside from the core fact and dimension tables what are some other table types in a dimensional data model?
Bridge, MappingFact, AttributeValueDim, DataMart, SetDim (groupers)
What is the difference between a lookup column and a foreign key?
Some lookup columns are Foreign keys and join to the Primary key of a destination table, and some are DurableKey columns and join to DurableKey columns in the destination table.
