Caboodle Administration - The Dimensional Data Model
Study online at https://quizlet.com/_6huaw8
1. Define "Normal- Normalized databases avoid redundancies in the data to make ETL safe and simple
ized data model"
2. Define "Dimen- 1. The data is more accessible
sional data mod- 2. Efficiency
el" 3. Fewer tables and simpler joins
3. Define "Con- There are many fact DMC's in Caboodle. Rather than define a complete set of
formed dimen- dimensions for each, it's wise to reuse them wherever possible. For example, most
sion" fact DMC's require a dimension describing patients, and they all reference the
same table (PatientDim) to do so. Dimensions that provide context to multiple facts
in this way are said to be conformed dimensions.
4. Define "Profile di- A "Profile Dimension" holds dimensional data that is specific to a single fact DMC.
mension"
5. Define " Surro- represents an entity in a moment in time.
gate key"
6. Define "Durable Every type 2 DMC has a column named DurableKey. This column contains the same
key" 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)
7. Define "Type 1 Historical values are NOT retained for type 1 data
data"
8. Define "Type 2 Caboodle retains historical values for type 2 data by creating multiple rows for each
data" entity, with each row containing the values for a particular time period.
9. Define "Business The business key of a record is the unique identifier it had in its source.
key"
In Caboodle, business keys are stored as a combination of two data points:
"IdType" and "Id"
1/3
Study online at https://quizlet.com/_6huaw8
1. Define "Normal- Normalized databases avoid redundancies in the data to make ETL safe and simple
ized data model"
2. Define "Dimen- 1. The data is more accessible
sional data mod- 2. Efficiency
el" 3. Fewer tables and simpler joins
3. Define "Con- There are many fact DMC's in Caboodle. Rather than define a complete set of
formed dimen- dimensions for each, it's wise to reuse them wherever possible. For example, most
sion" fact DMC's require a dimension describing patients, and they all reference the
same table (PatientDim) to do so. Dimensions that provide context to multiple facts
in this way are said to be conformed dimensions.
4. Define "Profile di- A "Profile Dimension" holds dimensional data that is specific to a single fact DMC.
mension"
5. Define " Surro- represents an entity in a moment in time.
gate key"
6. Define "Durable Every type 2 DMC has a column named DurableKey. This column contains the same
key" 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)
7. Define "Type 1 Historical values are NOT retained for type 1 data
data"
8. Define "Type 2 Caboodle retains historical values for type 2 data by creating multiple rows for each
data" entity, with each row containing the values for a particular time period.
9. Define "Business The business key of a record is the unique identifier it had in its source.
key"
In Caboodle, business keys are stored as a combination of two data points:
"IdType" and "Id"
1/3
