Caboodle Data Model Study Set Questions With Complete Solutions

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