A lookup column in Caboodle contains the value -3. What could this mean?
Give this one a try later!
There are two possibilities: Either the data that once populated this row in
Caboodle has been deleted from the source or this is the row with -3 as its
primary key, for which all lookup columns are also -3. To know which is true,
check the primary key value for the given row: a non-negative value
indicates that this row represents deleted data in the source.
True or False. All Caboodle tables have a DurableKey column.
Give this one a try later!
, False. Only tables with snapshot change tracking will have a column named
'DurableKey' used to identify the entity.
Log into Hyperspace as the Cogito Tools Administrator, open the Patients data model
in SlicerDicer, and click Troubleshoot. What is the purpose of the WHERE clause in this
data model?
Give this one a try later!
The WHERE clause (WHERE subq.DurableKey > 0) filters out the rows with
negative durable key values from PatientDim. Since these rows do not
represent actual patients, they should not be included in the total count of
patients in the Patients data model.
Identify the Caboodle table and column for the following data point: The medication's
generic name
Give this one a try later!
MedicationDim.GenericName
What join condition should be used in a join from EncounterFact to PatientDim?
Give this one a try later!
The join from EncounterFact to PatientDim should be:
FROM EncounterFact
INNER JOIN PatientDim
, ON EncounterFact.PatientDurableKey = PatientDim.DurableKey AND
PatientDim.IsCurrent = 1
Identify the Caboodle table and column for the following data point: The patient's age
at the time of the ED visit
Give this one a try later!
DurationDim.DisplayString
True or False: A column can either be a primary key or a surrogate key, but not both.
Give this one a try later!
False. A column can be both a primary key (the column(s) used to uniquely
identify a row) and a surrogate key (a key created during ETL that does not
exist in the source database). In Caboodle, primary key columns are also
surrogate keys.
How many SSIS packages can populate a single table in Caboodle.
A. A single SSIS package
B. Multiple SSIS packages all from Clarity
C. Multiple SSIS packages from multiple sources
Give this one a try later!
A, B, and C
Give this one a try later!
There are two possibilities: Either the data that once populated this row in
Caboodle has been deleted from the source or this is the row with -3 as its
primary key, for which all lookup columns are also -3. To know which is true,
check the primary key value for the given row: a non-negative value
indicates that this row represents deleted data in the source.
True or False. All Caboodle tables have a DurableKey column.
Give this one a try later!
, False. Only tables with snapshot change tracking will have a column named
'DurableKey' used to identify the entity.
Log into Hyperspace as the Cogito Tools Administrator, open the Patients data model
in SlicerDicer, and click Troubleshoot. What is the purpose of the WHERE clause in this
data model?
Give this one a try later!
The WHERE clause (WHERE subq.DurableKey > 0) filters out the rows with
negative durable key values from PatientDim. Since these rows do not
represent actual patients, they should not be included in the total count of
patients in the Patients data model.
Identify the Caboodle table and column for the following data point: The medication's
generic name
Give this one a try later!
MedicationDim.GenericName
What join condition should be used in a join from EncounterFact to PatientDim?
Give this one a try later!
The join from EncounterFact to PatientDim should be:
FROM EncounterFact
INNER JOIN PatientDim
, ON EncounterFact.PatientDurableKey = PatientDim.DurableKey AND
PatientDim.IsCurrent = 1
Identify the Caboodle table and column for the following data point: The patient's age
at the time of the ED visit
Give this one a try later!
DurationDim.DisplayString
True or False: A column can either be a primary key or a surrogate key, but not both.
Give this one a try later!
False. A column can be both a primary key (the column(s) used to uniquely
identify a row) and a surrogate key (a key created during ETL that does not
exist in the source database). In Caboodle, primary key columns are also
surrogate keys.
How many SSIS packages can populate a single table in Caboodle.
A. A single SSIS package
B. Multiple SSIS packages all from Clarity
C. Multiple SSIS packages from multiple sources
Give this one a try later!
A, B, and C
