Caboodle
Aggregating Snapshot statistics - ANS-Use DurableKey column to mixture rows
Bridge Tables - ANS-For many to many relationships which include patients and trouble list
diagnoses.
Two columns, <Name>ComboKey
<Name>Key
In complete get entry to, bridges are combined to the scale they hyperlink out to.
Caboodle - ANS-Data warehouse, facts supply for slicer dicer, dimensional statistics version
Caboodle Console - ANS-Contains dictionary editor, executions, the paintings queue, and
configuration. Used by means of caboodle admins for developing/handling executions and
caboodle builders for creating new statistics models.
Caboodle Database - ANS-Dimensional for ease of reporting and records exploration.
Caboodle Dictionary - ANS-Part of the caboodle console. Entries encompass residences,
resources, columns, and ER diagrams.
Contains simple table metadata. Used by way of BIDs.
Caboodle enforces referential integrity with the aid of: - ANS-Placing greater rows in every
desk (-1,-2,-3)
Applying default foreign key values (-1,-2,-three)
Creating inferred rows
Cardinality of durable key - ANS-one:many
Change Tracking - ANS-Can be found in Dictionary > Properties
No change tracking -desk contents mirror contemporary supply values
Snapshot change tracking -shops snapshots of a few supply information values
Tables have more columns -DurableKey, StartDate, EndDate, and IsCurrent
Based on Caboodle ETL dates
Chronicles Database - ANS-Heirarchical and actual time
Clarity Database - ANS-Relational, normalized statistics version
dbo schema - ANS-Caboodle dictionary, Slicer Dicer
Dimension Tables - ANS-Concrete entities that offer context
PatientDim
PatientKey- number one key
Aggregating Snapshot statistics - ANS-Use DurableKey column to mixture rows
Bridge Tables - ANS-For many to many relationships which include patients and trouble list
diagnoses.
Two columns, <Name>ComboKey
<Name>Key
In complete get entry to, bridges are combined to the scale they hyperlink out to.
Caboodle - ANS-Data warehouse, facts supply for slicer dicer, dimensional statistics version
Caboodle Console - ANS-Contains dictionary editor, executions, the paintings queue, and
configuration. Used by means of caboodle admins for developing/handling executions and
caboodle builders for creating new statistics models.
Caboodle Database - ANS-Dimensional for ease of reporting and records exploration.
Caboodle Dictionary - ANS-Part of the caboodle console. Entries encompass residences,
resources, columns, and ER diagrams.
Contains simple table metadata. Used by way of BIDs.
Caboodle enforces referential integrity with the aid of: - ANS-Placing greater rows in every
desk (-1,-2,-3)
Applying default foreign key values (-1,-2,-three)
Creating inferred rows
Cardinality of durable key - ANS-one:many
Change Tracking - ANS-Can be found in Dictionary > Properties
No change tracking -desk contents mirror contemporary supply values
Snapshot change tracking -shops snapshots of a few supply information values
Tables have more columns -DurableKey, StartDate, EndDate, and IsCurrent
Based on Caboodle ETL dates
Chronicles Database - ANS-Heirarchical and actual time
Clarity Database - ANS-Relational, normalized statistics version
dbo schema - ANS-Caboodle dictionary, Slicer Dicer
Dimension Tables - ANS-Concrete entities that offer context
PatientDim
PatientKey- number one key
