How can you track Caboodle upgrade progress?
Give this one a try later!
the Caboodle Changelog Assistant spreadsheet
True or False: A load package must populate all fields in a table?
,Give this one a try later!
False. A load package does not have to populate all fields in a table.
Define "Durable key"
Give this one a try later!
Every type 2 DMC has a column named DurableKey. This column contains
the same value for all the rows that belong to a specific entity. For example,
in PatientDim, all the rows corresponding to a specific patient will have the
same durable key. (each row will have a unique surrogate key)
When a new version of Caboodle is available what should your company review?
Give this one a try later!
Caboodle Changelog for documentation about enhancements, data model
changes, and fixes contained in the new version.
True or False: Naming conventions are enforced in Caboodle.
Give this one a try later!
True. Naming conventions are enforced in Caboodle.
,If a patient has a PCP assigned, but that providers' data hasn't been extracted to
ProviderDim, what value would appear in ProviderDim.name for this patient?
Give this one a try later!
*unknown (an inferred row)
What is the architecture of caboodle?
Give this one a try later!
Caboodle includes both staging and a reporting database. Data is
extracted from source systems, transformed in the staging database, and
presented for users in the reporting database. This movement of data is
realized via a set of SQL Server Integration Services (SSIS) packages. You
can also customize Caboodle by creating your own packages.
Define "Profile dimension"
Give this one a try later!
A "Profile Dimension" holds dimensional data that is specific to a single fact
DMC.
What is the "Confiruration" activity in Caboodle Console?
Give this one a try later!
, activity includes a variety of pages to manage and view important
information like system settings, user administration, component
configuration and more.
What is a "Not Applicable Foreign Key"?
Give this one a try later!
When a foreign key is not expected and NULL in the source,
it is said to be not applicable the value is set to -2
Every DMC has a row with a surrogate key of -2
What is Clarity?
Give this one a try later!
Clarity is a relational database with a normalized data
model.
Define "Type 2 data"
Give this one a try later!
Caboodle retains historical values for type 2 data by creating multiple rows
for each entity, with each row containing the values for a particular time
Give this one a try later!
the Caboodle Changelog Assistant spreadsheet
True or False: A load package must populate all fields in a table?
,Give this one a try later!
False. A load package does not have to populate all fields in a table.
Define "Durable key"
Give this one a try later!
Every type 2 DMC has a column named DurableKey. This column contains
the same value for all the rows that belong to a specific entity. For example,
in PatientDim, all the rows corresponding to a specific patient will have the
same durable key. (each row will have a unique surrogate key)
When a new version of Caboodle is available what should your company review?
Give this one a try later!
Caboodle Changelog for documentation about enhancements, data model
changes, and fixes contained in the new version.
True or False: Naming conventions are enforced in Caboodle.
Give this one a try later!
True. Naming conventions are enforced in Caboodle.
,If a patient has a PCP assigned, but that providers' data hasn't been extracted to
ProviderDim, what value would appear in ProviderDim.name for this patient?
Give this one a try later!
*unknown (an inferred row)
What is the architecture of caboodle?
Give this one a try later!
Caboodle includes both staging and a reporting database. Data is
extracted from source systems, transformed in the staging database, and
presented for users in the reporting database. This movement of data is
realized via a set of SQL Server Integration Services (SSIS) packages. You
can also customize Caboodle by creating your own packages.
Define "Profile dimension"
Give this one a try later!
A "Profile Dimension" holds dimensional data that is specific to a single fact
DMC.
What is the "Confiruration" activity in Caboodle Console?
Give this one a try later!
, activity includes a variety of pages to manage and view important
information like system settings, user administration, component
configuration and more.
What is a "Not Applicable Foreign Key"?
Give this one a try later!
When a foreign key is not expected and NULL in the source,
it is said to be not applicable the value is set to -2
Every DMC has a row with a surrogate key of -2
What is Clarity?
Give this one a try later!
Clarity is a relational database with a normalized data
model.
Define "Type 2 data"
Give this one a try later!
Caboodle retains historical values for type 2 data by creating multiple rows
for each entity, with each row containing the values for a particular time
