CDW 110V CABOODLE DATA MODEL FINAL
PAPER UPDATED QUESTIONS VERIFIED
COMPLETE ANSWERS 100 PERCENT
CORRECT
◉ Identify the Caboodle table and column for the following data
point: The patient's phone number
Answer: PatientDim.HomePhoneNumber
◉ Identify the Caboodle table and column for the following data
point: The patient's MyChart Status
Answer: PatientDim.MyChartStatus
◉ Identify the Caboodle table and column for the following data
point: Column to identify deleted primary care providers
Answer: ProviderDim._IsDeleted = 1
◉ Suppose you're creating a report using EncounterFact and
ProviderDim that displays the name of each provider for each
encounter. If an encounter's data loads into EncounterFact, but that
provider's data hasn't been extracted to ProviderDim, what value
would appear in ProviderDim.Name for this encounter?
, Answer: There would be an inferred row in ProviderDim, therefore
ProviderDim.Name would show "*Unknown" for the encounter.
◉ A lookup column in Caboodle contains the value -3. What could
this mean?
Answer: 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.
◉ If a lookup column is null in Clarity, what will appear in the
corresponding column in Caboodle?
Answer: If the lookup column was null in the source and the SSIS
package defines the data lineage, then a -1 will appear in Caboodle
to represent an unspecified value. If the look up columns's data
lineage was not defined by the SSIS package that loaded data for a
particular row, then a -2 will appear in Caboodle to represent a value
that is not applicable.
◉ 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?
Answer: The WHERE clause (WHERE subq.DurableKey > 0) filters
out the rows with negative durable key values from PatientDim.
PAPER UPDATED QUESTIONS VERIFIED
COMPLETE ANSWERS 100 PERCENT
CORRECT
◉ Identify the Caboodle table and column for the following data
point: The patient's phone number
Answer: PatientDim.HomePhoneNumber
◉ Identify the Caboodle table and column for the following data
point: The patient's MyChart Status
Answer: PatientDim.MyChartStatus
◉ Identify the Caboodle table and column for the following data
point: Column to identify deleted primary care providers
Answer: ProviderDim._IsDeleted = 1
◉ Suppose you're creating a report using EncounterFact and
ProviderDim that displays the name of each provider for each
encounter. If an encounter's data loads into EncounterFact, but that
provider's data hasn't been extracted to ProviderDim, what value
would appear in ProviderDim.Name for this encounter?
, Answer: There would be an inferred row in ProviderDim, therefore
ProviderDim.Name would show "*Unknown" for the encounter.
◉ A lookup column in Caboodle contains the value -3. What could
this mean?
Answer: 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.
◉ If a lookup column is null in Clarity, what will appear in the
corresponding column in Caboodle?
Answer: If the lookup column was null in the source and the SSIS
package defines the data lineage, then a -1 will appear in Caboodle
to represent an unspecified value. If the look up columns's data
lineage was not defined by the SSIS package that loaded data for a
particular row, then a -2 will appear in Caboodle to represent a value
that is not applicable.
◉ 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?
Answer: The WHERE clause (WHERE subq.DurableKey > 0) filters
out the rows with negative durable key values from PatientDim.
