Exam (elaborations)
COG280-04 Feb2025 Cogito Systems Administration I - Caboodle and SlicerDicer ETL latest update
- Course
- Institution
COG280-04 Feb2025 Cogito Systems Administration I - Caboodle and SlicerDicer ETL latest update
[Show more]
Content preview
COG280-04 Feb2025 CogitoSystems Administration I -
Caboodle and SlicerDicer ETL
latest update with 100%
correct answers(graded A+)
CHAPTER 8 - Caboodle Record Matching
What do you need to do to match non-Epic and Epic Records in
Caboodle? HINT: answers to 2 Questions - answer CHAPTER 8 -
Caboodle Record Matching
To match records, Caboodle needs to know the answers to :
1. What records are being matched (patients, providers, etc.) and
what is the corresponding DMC?
2. What specific business keys should be matched together?
What is the best place in Chronicles to match records in Caboodle?
(NOTE Chronicles as a place to match) - answer - Patient Load
Utility owned by the Identity team
- Roster Management Engine owned by the Healthy Planet team
What is the format for matching Chronicles IIT .1 and Caboodle
IdType?
HINT: EpicIdentityINI### - answer EpicIdentityINI###
Example: SER records were matched with IT ID 885.
The corresponding IdType in Caboodle would be EpicIdentitySer885.
In Caboodle, how do you view the lineage of IdentityInfo Package
that uses EpicIdentity IdType for matching records? - answer 1. In
,the Dictionary Editor, open the IdentityInfo package Provider
Identity Mapping Load
2. On the Data Lineage form, note the expressions for the
MapFromIdType and MapToIdType columns
Which is the Main Patient Table in Caboodle DM? - answer -
PatientDim
is the Main Patient Table in Caboodle DM
Name the two SlicerDicer dBs - answer - SlicerDicer DATA dB
- SlicerDicer STATS dB
TRUE or FALSE
It's possible that in our org SlicerDicer DATA dB and STATS dB could
be the same dB, "The SlicerDicer dB", two-in-one - answer TRUE
It's possible that in our org SlicerDicer DATA dB and STATS dB could
be the same dB, "The SlicerDicer dB", two-in-one
How do you query SlicerDicer for ResultCache? - answer use
SlicerDicer29
Select * from ResultCache
There is new SlicerDicer App called SD JumpStart. What is it for? -
answer To monitor and pre-calcucalte a lot of various current and
cached activities on Caboodle, SlicerDicer and elsewhere.
What does JumpStart pre-calculate? Hint: 3 things - answer
JumpStart pre-calculates THREE things:
- The count of records in each DM (i.e. FDM record)
- The results of all SlicerDicer components on Radar dashboards
, - The values to include in the HasEver indexes, which controls what
users can search for or select from drop‐down menus in SlicerDicer
When you open JumpStart activity, what do you see? - answer In
JumpStart, you see rectangular icons that represent statuses for:
- Caboodle
- JumpStart
- Overall Progress
- Fulltext Index Progress
- Data Freshness
- HasEver Progress
- Component Progress
- Errors
- Validation Warnings
- Updated Components
- CPU/RAM Usage
How can you see details in JumpStart? - answer You can click any
component except CPU and RAM Usage to see more details
Which Server are the SlicerDicer dBs located? - answer Caboodle
Server
How do you view SlicerDicer Stats in SQL Server Studio? - answer
use SlicerDicerStats29
select * from stats_query
In Clarity, how is Delay and BF Depletion Exec is different from an
ETL Execution? - answer - It's also an ETL Type exec
- However, it's Extract Type is "Continuous BF ad Delay Depletion"
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller GUARANTEEDSUCCESS. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $15.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
80461 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now