Facts and Dimensions Flashcards Preview

CDW110v Caboodle Fundamentals > Facts and Dimensions > Flashcards

Flashcards in Facts and Dimensions Deck (7)
Loading flashcards...
1
Q

In a dimensional data model the core tables are…

A

facts and dimensions

2
Q

A row in a fact table corresponds to…

A

some significant, measurable event.

Ex: ordering a medication, posting a charge transaction

3
Q

A row in a dimension table represents…

A

a concrete entity that provides context for some event in a fact table.
Ex: Patient, Pharmacy, or Billing Provider

4
Q

A fact table contains relevant metrics and lookup columns. Another term for a lookup column is…

A

foreign key

5
Q

In Caboodle all fact and dimension tables use a ___________ as their primary key.

A

surrogate key

6
Q

Aside from the core fact and dimension tables what are some other table types in a dimensional data model?

A

Bridge, MappingFact, AttributeValueDim, DataMart, SetDim (groupers)

7
Q

What is the difference between a lookup column and a foreign key?

A

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.