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.
Name some advantages of a dimensional database.
ETL does the join work so that the reporting analyst doesn’t have to.
What type of data model structure is Caboodle based on?
A “Star Schema” where one central fact table will join to many associated lookup or dimension tables.
Caboodle consists of two databases, what are they?
The staging database and the reporting database.
Why does Caboodle have a staging database?
The data extracted from Chronicles is transformed in the staging database, and presented for users in the reporting database.
What is a Data Model Component?
A collection of metadata tables that support the ETL process and the reporting views stored in the FullAccess schema.
