Intro Flashcards
T/F Surrogate key column names match the name of the table.
True
T/F BirthFact.BirthEpicId is an example of a primary key.
False
Some Caboodle tables have a column called DurableKey. Why is that?
Type 2 data tracked over time will require a DurableKey. The DurableKey retains the same value across multiple rows.
T/F All lookup columns end in the word Key.
True
T/F Foreign keys in a table match to Primary keys in a destination (lookup) table.
True
Ex: BirthFact.MotherPatientKey
PatientDim.PrimaryCareProvider
How can lookup columns or foreign keys be identified in the Dictionary ?
They have a “Links to” hyperlink
In Caboodle, Can a fact table have a lookup column to another fact table?
Yes
In MedicationDim, What is the difference between MedicationKey and MedicationEpicID?
MedicationKey is the primary/surrogate Caboodle identifier while MedicationEpicId is the Epic ID for that medication.
T/F A maximum of one foreign key can exist between two tables in Caboodle.
False
Ex:
What is the granularity of DepartmentDim?
A bed/room/room grp/care area/submitter/department/location/service area
Can a single table be populated by more than one package?
Yes
T/F Caboodle and Clarity can be used interchangeably.
False
Which is an example of a normalized database, Clarity or Caboodle?
Clarity is a normalized database.
Can a row in a table be populated by more than one package?
Yes
Caboodle is an example of what type of database?
Caboodle is a dimensional database. Joins are more intuitive and centralize around flexible fact and dimension tables.
