Caboodle Data Model Study Set
_IsInferred Column - ANS-Identifies rows which might be inferred. 5-19
AttributeDim - ANS-The desk that stores the listing of all attributes used by the
AttributeValueDim system in Caboodle is known as AttributeDim. It has one row in keeping
with attribute and incorporates the name of the characteristic ﴾in addition to a few additional
metadata﴿. 6-6
AttributeValueDims - ANS-DMC, those tables comprise characteristic‐cost pairs and may be
created for one-of-a-kind entities. 6-6
Bridge Tables - ANS-Capture many-to-many relationships. Every bridge table has two
columns. They are referred to as <Name>ComboKey and <Name>Key, in which is the call of
the table to which a bridge has been fashioned. The Key column can be used as a lookup
column to link to the corresponding dimension desk. The ComboKey column is a surrogate
key that represents a completely unique combination of Key values. 6-4
Bridge Tables in FullAccess Schema - ANS-In the FullAccess schema, bridge tables are
mixed with the measurement they hyperlink out to in a view that has the equal name as the
bridge desk. For example, FullAccess.DiagnosisBridge incorporates the name of the
prognosis, even though the call is stored in dbo.DiagnosisDim. 6-4
Caboodle - ANS-A facts warehouse, designed to save Epic and non-Epic information. 2-4
Caboodle Dictionary - ANS-Part of the Cogito Dictionary in Hyperspace included into the
Analytics Catalog. Used to research Caboodle database objects. Three-4
Caboodle desk naming conventions - ANS-Dim for dimensions, Fact for statistics, Bridge for
bridges, DataMart for data marts, AtributeValueDim for EAV tables, <suffix>X for custom
tables. 2-10
Change Tracking - ANS-Change tracking is a assets of a table that informs us how Caboodle
will be up to date while modifications are made to the source databases. In Caboodle, there
are forms of exchange monitoring which might be viable. Four-4
Data Mart - ANS-Data marts normally function complete data resources for a selected
reporting want, making it simpler for business intelligence developers to write down unique
reviews. 6-9
dbo schema - ANS-Data supply for SlicerDicer. 2-6
, Durable Key - ANS-Snapshot tables have a long lasting key column which shops the equal
cost for all rows that correspond to the same entity. This lets in for correct grouping and
summarizing. Used while aggregating data. 4-eleven
ER Diagram - ANS-This phase in the dictionary can be available for Facts and DataMarts.
Built in a celeb schema layout with investigated table in the center. Three-6
ETL technique for Caboodle - ANS-Caboodle receives information from Clarity (Epic Data)
and from different databases (non-Epic statistics). 2-five
Explain the connection between the dbo and FullAccess schemas. - ANS-The Cogito
Dictionary displays the dbo schema. The FullAccess schema incorporates almost the whole
thing in the dbo schema (minus some metadata columns) plus additional columns in some
tables. Since FullAccess has greater facts, record writers have to use it when writing
queries. However, record writers must additionally be familiar with dbo due to its courting
with the Cogito Dictionary. 2-15
FullAccess schema - ANS-incorporates the whole thing for report writers from the dbo
schema and greater. 2-6
How can you decide which Clarity column is used to populate the Caboodle column? -
ANS-Investigate the information lineage for the column using the Cogito Dictionary. Three-13
How do you decide which caboodle desk and column extracts a certain set of statistics out of
Clarity? - ANS-Search the Cogito Dictionary and restriction the search consequences to
ONLY Caboodle. Three-thirteen
How many SSIS programs can populate a single desk in Caboodle - ANS-unmarried SSIS
package, Multiple SSIS programs all from Clarity, and Multiple SSIS applications from more
than one sources three-thirteen
Identifying Change Tracking - ANS-If a desk is the use of Snapshot change tracking
﴾additionally referred to as Type 2﴿, there may be a chip in the evaluation segment of the
desk that states this. These tables will song modifications to the photograph statistics. If no
chip is gift, the desk, and all of its columns, are considered Non‐snapshot, or Type 1. Four-4
Inferred Rows - ANS-while a lookup column cost does now not use one of the default values
and also does now not have a match in the vacation spot desk. Inferred rows may be notion
of as placeholder rows. Caboodle reserves a space for the inferred entity by using
developing a row. Eventually the ETL procedure will replace those default values while the
facts is populated inside the source database. 5-18
IsCurrent column - ANS-a flag that stores the value of one if the row holds the maximum
contemporary information and 0 otherwise. Four-8
Join Diagrams - ANS-Visual representations of the tables, columns, and joins concerned in a
question. 3-9
_IsInferred Column - ANS-Identifies rows which might be inferred. 5-19
AttributeDim - ANS-The desk that stores the listing of all attributes used by the
AttributeValueDim system in Caboodle is known as AttributeDim. It has one row in keeping
with attribute and incorporates the name of the characteristic ﴾in addition to a few additional
metadata﴿. 6-6
AttributeValueDims - ANS-DMC, those tables comprise characteristic‐cost pairs and may be
created for one-of-a-kind entities. 6-6
Bridge Tables - ANS-Capture many-to-many relationships. Every bridge table has two
columns. They are referred to as <Name>ComboKey and <Name>Key, in which is the call of
the table to which a bridge has been fashioned. The Key column can be used as a lookup
column to link to the corresponding dimension desk. The ComboKey column is a surrogate
key that represents a completely unique combination of Key values. 6-4
Bridge Tables in FullAccess Schema - ANS-In the FullAccess schema, bridge tables are
mixed with the measurement they hyperlink out to in a view that has the equal name as the
bridge desk. For example, FullAccess.DiagnosisBridge incorporates the name of the
prognosis, even though the call is stored in dbo.DiagnosisDim. 6-4
Caboodle - ANS-A facts warehouse, designed to save Epic and non-Epic information. 2-4
Caboodle Dictionary - ANS-Part of the Cogito Dictionary in Hyperspace included into the
Analytics Catalog. Used to research Caboodle database objects. Three-4
Caboodle desk naming conventions - ANS-Dim for dimensions, Fact for statistics, Bridge for
bridges, DataMart for data marts, AtributeValueDim for EAV tables, <suffix>X for custom
tables. 2-10
Change Tracking - ANS-Change tracking is a assets of a table that informs us how Caboodle
will be up to date while modifications are made to the source databases. In Caboodle, there
are forms of exchange monitoring which might be viable. Four-4
Data Mart - ANS-Data marts normally function complete data resources for a selected
reporting want, making it simpler for business intelligence developers to write down unique
reviews. 6-9
dbo schema - ANS-Data supply for SlicerDicer. 2-6
, Durable Key - ANS-Snapshot tables have a long lasting key column which shops the equal
cost for all rows that correspond to the same entity. This lets in for correct grouping and
summarizing. Used while aggregating data. 4-eleven
ER Diagram - ANS-This phase in the dictionary can be available for Facts and DataMarts.
Built in a celeb schema layout with investigated table in the center. Three-6
ETL technique for Caboodle - ANS-Caboodle receives information from Clarity (Epic Data)
and from different databases (non-Epic statistics). 2-five
Explain the connection between the dbo and FullAccess schemas. - ANS-The Cogito
Dictionary displays the dbo schema. The FullAccess schema incorporates almost the whole
thing in the dbo schema (minus some metadata columns) plus additional columns in some
tables. Since FullAccess has greater facts, record writers have to use it when writing
queries. However, record writers must additionally be familiar with dbo due to its courting
with the Cogito Dictionary. 2-15
FullAccess schema - ANS-incorporates the whole thing for report writers from the dbo
schema and greater. 2-6
How can you decide which Clarity column is used to populate the Caboodle column? -
ANS-Investigate the information lineage for the column using the Cogito Dictionary. Three-13
How do you decide which caboodle desk and column extracts a certain set of statistics out of
Clarity? - ANS-Search the Cogito Dictionary and restriction the search consequences to
ONLY Caboodle. Three-thirteen
How many SSIS programs can populate a single desk in Caboodle - ANS-unmarried SSIS
package, Multiple SSIS programs all from Clarity, and Multiple SSIS applications from more
than one sources three-thirteen
Identifying Change Tracking - ANS-If a desk is the use of Snapshot change tracking
﴾additionally referred to as Type 2﴿, there may be a chip in the evaluation segment of the
desk that states this. These tables will song modifications to the photograph statistics. If no
chip is gift, the desk, and all of its columns, are considered Non‐snapshot, or Type 1. Four-4
Inferred Rows - ANS-while a lookup column cost does now not use one of the default values
and also does now not have a match in the vacation spot desk. Inferred rows may be notion
of as placeholder rows. Caboodle reserves a space for the inferred entity by using
developing a row. Eventually the ETL procedure will replace those default values while the
facts is populated inside the source database. 5-18
IsCurrent column - ANS-a flag that stores the value of one if the row holds the maximum
contemporary information and 0 otherwise. Four-8
Join Diagrams - ANS-Visual representations of the tables, columns, and joins concerned in a
question. 3-9
