What Clarity table acts as the primary source for data in EpisodeFact?
Give this one a try later!
Episode.
Define "Profile dimension"
Give this one a try later!
A "Profile Dimension" holds dimensional data that is specific to a single fact
DMC.
Which of the following types of columns would you find in a type 1 table?
,Give this one a try later!
Surrogate key, foreign key, and a combo key.
Define "Conformed dimension"
Give this one a try later!
There are many fact DMC's in Caboodle. Rather than define a complete set
of dimensions for each, it's wise to reuse them wherever possible. For
example, most 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.
Why do profile dimensions have fewer rows than their parent fact tables?
Give this one a try later!
A row in a profile dimension represents a unique combination of values (for
example, VisitProfileDim stores unique combinations of encounter type,
visit type, and financial class). Since combinations aren't repeated, profile
dimensions must contain fewer rows than their parent fact table.
Additionally, the data points in a profile dimension often come from
category lists in Chronicles, so there's a limited number of possible values
they can take on.
What is Chronicles?
,Give this one a try later!
Chronicles is Epic's operational database. Written in the M
programming language, Chronicles is optimized to support
end users in their day-to-day work. Data entered here is
extracted, on a nightly basis, to Clarity.
Define "IdType"
Give this one a try later!
the IdType column contains a string value that specifies the type of entity
loaded
What is the "Caboodle Maintenance and Monitoring Guide"?
Give this one a try later!
configuration, troubleshooting, and performance tuning for ETL
administrators, including upgrade steps.
What is "X" table naming convention?
Give this one a try later!
custom tables (e.g. CustomFactX)
, Which of the following are possible to do in Caboodle?
Give this one a try later!
Joining a fact table to another fact table, Fact table to dimension table,
dimension table to dimension table, 2 different EAV dim table to an
attribute dim table
What is "Info" table naming convention?
Give this one a try later!
informational tables (e.g. IdentityInfo)
What two columns do all Bridge tables have?
Give this one a try later!
Every Bridge table has a Combo key to which other tables join, and a
foreign key to join to its associated Dim table.
Give this one a try later!
Episode.
Define "Profile dimension"
Give this one a try later!
A "Profile Dimension" holds dimensional data that is specific to a single fact
DMC.
Which of the following types of columns would you find in a type 1 table?
,Give this one a try later!
Surrogate key, foreign key, and a combo key.
Define "Conformed dimension"
Give this one a try later!
There are many fact DMC's in Caboodle. Rather than define a complete set
of dimensions for each, it's wise to reuse them wherever possible. For
example, most 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.
Why do profile dimensions have fewer rows than their parent fact tables?
Give this one a try later!
A row in a profile dimension represents a unique combination of values (for
example, VisitProfileDim stores unique combinations of encounter type,
visit type, and financial class). Since combinations aren't repeated, profile
dimensions must contain fewer rows than their parent fact table.
Additionally, the data points in a profile dimension often come from
category lists in Chronicles, so there's a limited number of possible values
they can take on.
What is Chronicles?
,Give this one a try later!
Chronicles is Epic's operational database. Written in the M
programming language, Chronicles is optimized to support
end users in their day-to-day work. Data entered here is
extracted, on a nightly basis, to Clarity.
Define "IdType"
Give this one a try later!
the IdType column contains a string value that specifies the type of entity
loaded
What is the "Caboodle Maintenance and Monitoring Guide"?
Give this one a try later!
configuration, troubleshooting, and performance tuning for ETL
administrators, including upgrade steps.
What is "X" table naming convention?
Give this one a try later!
custom tables (e.g. CustomFactX)
, Which of the following are possible to do in Caboodle?
Give this one a try later!
Joining a fact table to another fact table, Fact table to dimension table,
dimension table to dimension table, 2 different EAV dim table to an
attribute dim table
What is "Info" table naming convention?
Give this one a try later!
informational tables (e.g. IdentityInfo)
What two columns do all Bridge tables have?
Give this one a try later!
Every Bridge table has a Combo key to which other tables join, and a
foreign key to join to its associated Dim table.
