Caboodle Data Model Study Set Questions
With Complete Solutions
Caboodle A data warehouse, designed to store Epic and non-Epic data. 2-4
ETL process for Caboodle Caboodle receives data from Clarity (Epic Data) and from
other databases (non-Epic data). 2-5
SSIS Package SQL Server Integration Services are the mechanisms used to move data
during the Caboodle ETL process. 2-5
Schema A collection of database objects. 2-6
dbo schema Data source for SlicerDicer. 2-6
FullAccess schema contains everything for report writers from the dbo schema and more.
2-6
Why use Caboodle over Clarity? Caboodle stores Epic and Non-Epic Data, hyperspace
integration, simplified report writing, enforced naming conventions. 2-8, 2-9, 2-10
, Caboodle Data Model Study Set Questions
With Complete Solutions
Caboodle table naming conventions Dim for dimensions, Fact for facts, Bridge for
bridges, DataMart for data marts, AtributeValueDim for EAV tables, <suffix>X for custom
tables. 2-10
Surrogate Key ‐ Any key column where the column's value does not exist in the source
database and is created during the ETL process. In Caboodle all columns that end in ‐Key are
surrogate keys. This is necessary because Caboodle contains both Epic and non‐Epic data. 2-10
Lookup Column A column in one table whose value identifies at least one row in another
table. Most tables in Caboodle have at least one lookup column. Lookup columns in Caboodle
will always end in ‐Key and the Cogito Dictionary will tell report writers what DMC the lookup
column references. 2-10
Star Schema refers to the way that reports centered around fact tables appear in a join
diagram. 2-11
With Complete Solutions
Caboodle A data warehouse, designed to store Epic and non-Epic data. 2-4
ETL process for Caboodle Caboodle receives data from Clarity (Epic Data) and from
other databases (non-Epic data). 2-5
SSIS Package SQL Server Integration Services are the mechanisms used to move data
during the Caboodle ETL process. 2-5
Schema A collection of database objects. 2-6
dbo schema Data source for SlicerDicer. 2-6
FullAccess schema contains everything for report writers from the dbo schema and more.
2-6
Why use Caboodle over Clarity? Caboodle stores Epic and Non-Epic Data, hyperspace
integration, simplified report writing, enforced naming conventions. 2-8, 2-9, 2-10
, Caboodle Data Model Study Set Questions
With Complete Solutions
Caboodle table naming conventions Dim for dimensions, Fact for facts, Bridge for
bridges, DataMart for data marts, AtributeValueDim for EAV tables, <suffix>X for custom
tables. 2-10
Surrogate Key ‐ Any key column where the column's value does not exist in the source
database and is created during the ETL process. In Caboodle all columns that end in ‐Key are
surrogate keys. This is necessary because Caboodle contains both Epic and non‐Epic data. 2-10
Lookup Column A column in one table whose value identifies at least one row in another
table. Most tables in Caboodle have at least one lookup column. Lookup columns in Caboodle
will always end in ‐Key and the Cogito Dictionary will tell report writers what DMC the lookup
column references. 2-10
Star Schema refers to the way that reports centered around fact tables appear in a join
diagram. 2-11
