CDW110v Caboodle Data Model
Fundamentals
A column in Caboodle does now not comprise the facts you count on to see. To decide if the
issue is within the supply information or the ETL technique, you need to research the Clarity
statistics. How can you decide which Clarity column is used to populate the Caboodle
column? - ANS-Investigate the information lineage for the column the use of the Cogito
Dictionary.
A research column in Caboodle incorporates the price -three. What may want to this
suggest? - ANS-There are opportunities: Either the facts that after populated this row in
Caboodle has been deleted from the source or this is the row with -3 as its number one key,
for which all research columns also are -3. To recognise that is genuine, take a look at the
primary key fee for the given row: a non-poor value suggests that this row represents
deleted data in the supply.
A row in a Caboodle table has a number one key price of -2. What fee can be stored in
columns with a data kind of "Date" for this row that aren't lookup columns?
A. -2
B. NULL
C. 12/31/1840
D. *Not Applicable - ANS-b. NULL, For the row with a number one key of -2, research
columns will store a value of -2, string columns will shop '*Not Applicable', and all different
information kind columns will store NULL.
Consider the subsequent question:
SELECT DurableKey FROM <TableName>
Which of the following statements are authentic?
A. This question will handiest run if <TableName> is a snapshot desk
B. This query will run no matter whether <TableName> has change monitoring
C. The fee inside the DurableKey column should repeat in a couple of rows of the outcomes
D. There is no desk in Caboodle for which this question will run - ANS-A. This question will
best run if <TableName> is a picture table, and C. The value in the DurableKey column may
want to repeat in more than one rows of the results
Explain the connection among the dbo and FullAccess schemas. - ANS-The Cogito
Dictionary reflects the dbo schema. The FullAccess schema includes almost the whole lot in
the dbo schema (minus a few metadata columns) plus additional columns in a few tables.
Since FullAccess has more information, record writers ought to use it when writing queries.
, However, report writers ought to also be acquainted with dbo due to its relationship with the
Cogito Dictionary.
How does records get into Caboodle? - ANS-Data receives into Caboodle thru SSIS
applications from Clarity or a 3rd birthday celebration database.
How many SSIS packages can populate a unmarried desk in Caboodle.
A. A unmarried SSIS package
B. Multiple SSIS packages all from Clarity
C. Multiple SSIS programs from a couple of sources - ANS-A, B, and C
Identify the Caboodle table and column for the subsequent facts factor, INI, and Item #:
Administration Date, I LPL 4010 - ANS-ImmunizationEventFact.AdministrationDateKey
Identify the Caboodle table and column for the following records point, INI, and Item #:
Encounter CSN, I EPT 8 - ANS-EncounterFact.EncounterEpicCsn
Identify the Caboodle desk and column for the subsequent facts point, INI, and Item #:
Immunization Name, I LIM .2 - ANS-ImmunizationDim.Name
Identify the Caboodle desk and column for the subsequent data factor, INI, and Item #:
Patient's Age, none - ANS-ImmunizationEventFact.AgeKey
Identify the Caboodle table and column for the following data point, INI, and Item #: The
immunizations in the VCG grouper, I VCG .1 - ANS-ImmunizationSetDim.ValueSetEpicId =
'1137225'
Identify the Caboodle desk and column for the subsequent information factor: Allergen's Epic
ID (ELG .1) - ANS-AllergenDim.AllergenEpicId
Identify the Caboodle desk and column for the following records factor: Allergen's Name
(ELG .2) - ANS-AllergenDim.Name
Identify the Caboodle table and column for the following information factor: Allergy Severity
(ECT 7150) - ANS-AllergyFact.Severity
Identify the Caboodle table and column for the following data point: Allergy Status (LPL
3030) - ANS-AllergyFact.Status
Identify the Caboodle table and column for the subsequent data factor: Column within the
-Fact desk to cast off deleted information - ANS-MedicationOrderFact._IsDeleted = zero
Identify the Caboodle desk and column for the subsequent records factor: Column to pick
out deleted primary care vendors - ANS-ProviderDim._IsDeleted = 1
Identify the Caboodle table and column for the following records point: Column to perceive
inferred patients - ANS-PatientDim._IsInferred
Fundamentals
A column in Caboodle does now not comprise the facts you count on to see. To decide if the
issue is within the supply information or the ETL technique, you need to research the Clarity
statistics. How can you decide which Clarity column is used to populate the Caboodle
column? - ANS-Investigate the information lineage for the column the use of the Cogito
Dictionary.
A research column in Caboodle incorporates the price -three. What may want to this
suggest? - ANS-There are opportunities: Either the facts that after populated this row in
Caboodle has been deleted from the source or this is the row with -3 as its number one key,
for which all research columns also are -3. To recognise that is genuine, take a look at the
primary key fee for the given row: a non-poor value suggests that this row represents
deleted data in the supply.
A row in a Caboodle table has a number one key price of -2. What fee can be stored in
columns with a data kind of "Date" for this row that aren't lookup columns?
A. -2
B. NULL
C. 12/31/1840
D. *Not Applicable - ANS-b. NULL, For the row with a number one key of -2, research
columns will store a value of -2, string columns will shop '*Not Applicable', and all different
information kind columns will store NULL.
Consider the subsequent question:
SELECT DurableKey FROM <TableName>
Which of the following statements are authentic?
A. This question will handiest run if <TableName> is a snapshot desk
B. This query will run no matter whether <TableName> has change monitoring
C. The fee inside the DurableKey column should repeat in a couple of rows of the outcomes
D. There is no desk in Caboodle for which this question will run - ANS-A. This question will
best run if <TableName> is a picture table, and C. The value in the DurableKey column may
want to repeat in more than one rows of the results
Explain the connection among the dbo and FullAccess schemas. - ANS-The Cogito
Dictionary reflects the dbo schema. The FullAccess schema includes almost the whole lot in
the dbo schema (minus a few metadata columns) plus additional columns in a few tables.
Since FullAccess has more information, record writers ought to use it when writing queries.
, However, report writers ought to also be acquainted with dbo due to its relationship with the
Cogito Dictionary.
How does records get into Caboodle? - ANS-Data receives into Caboodle thru SSIS
applications from Clarity or a 3rd birthday celebration database.
How many SSIS packages can populate a unmarried desk in Caboodle.
A. A unmarried SSIS package
B. Multiple SSIS packages all from Clarity
C. Multiple SSIS programs from a couple of sources - ANS-A, B, and C
Identify the Caboodle table and column for the subsequent facts factor, INI, and Item #:
Administration Date, I LPL 4010 - ANS-ImmunizationEventFact.AdministrationDateKey
Identify the Caboodle table and column for the following records point, INI, and Item #:
Encounter CSN, I EPT 8 - ANS-EncounterFact.EncounterEpicCsn
Identify the Caboodle desk and column for the subsequent facts point, INI, and Item #:
Immunization Name, I LIM .2 - ANS-ImmunizationDim.Name
Identify the Caboodle desk and column for the subsequent data factor, INI, and Item #:
Patient's Age, none - ANS-ImmunizationEventFact.AgeKey
Identify the Caboodle table and column for the following data point, INI, and Item #: The
immunizations in the VCG grouper, I VCG .1 - ANS-ImmunizationSetDim.ValueSetEpicId =
'1137225'
Identify the Caboodle desk and column for the subsequent information factor: Allergen's Epic
ID (ELG .1) - ANS-AllergenDim.AllergenEpicId
Identify the Caboodle desk and column for the following records factor: Allergen's Name
(ELG .2) - ANS-AllergenDim.Name
Identify the Caboodle table and column for the following information factor: Allergy Severity
(ECT 7150) - ANS-AllergyFact.Severity
Identify the Caboodle table and column for the following data point: Allergy Status (LPL
3030) - ANS-AllergyFact.Status
Identify the Caboodle table and column for the subsequent data factor: Column within the
-Fact desk to cast off deleted information - ANS-MedicationOrderFact._IsDeleted = zero
Identify the Caboodle desk and column for the subsequent records factor: Column to pick
out deleted primary care vendors - ANS-ProviderDim._IsDeleted = 1
Identify the Caboodle table and column for the following records point: Column to perceive
inferred patients - ANS-PatientDim._IsInferred
