Exam (elaborations)
CDW110v Caboodle Data Model Fundamentals 2024/2025 (100% verified) A+ graded by experts
- Course
- Institution
CDW110v Caboodle Data Model Fundamentals 2024/2025 (100% verified) A+ graded by experts
[Show more]
2 reviews
By: minakshidas • 4 months ago
By: Qualitydocs • 4 months ago
Thank you for the review, I appreciate your feedback and feel free to reach out for more resourceful documents. All the best in your studies.
By: hema1219 • 7 months ago
By: Qualitydocs • 7 months ago
Thank you for the review, I appreciate your feedback and feel free to reach out for more resourceful documents. All the best in your studies
Content preview
CDW1 10vCaboodle
Data
Model
Fundamentals
Caboodle
Dictionary
-
ANSBasic
metadata
for
tables.
Find
Descriptions
of
tables
and
columns
available
in
data
model.
Identify
tables
that
can
be
linked
together.
Caboodle
Dictionary
Editor
-
ANSIn
depth
view
of
Caboodle
ETL
packages
and
data
lineage.
Shows
Clarity
tables
data
that
extracted
from
when
populating
tables,
which
ETL
packages
are
used
by
Caboodle
tables
and
dependencies
amongst
the
tables
in
Caboodle.
Caboodle
Executions
-
ANSWhere
Caboodle
administrators
can
create,
edit,
run
and
monitor
executions.
Can
be
used
to
schedule
recurring
executions.
Caboodle
Workqueues
-
ANSLogs
the
different
types
of
issues
that
can
occur
during
the
ETL
process
that
require
manual
intervention
to
resolve.
Caboodle
configurations
-
ANSmodify
settings,
perform
customizations
such
as
adding
attributes
to
the
data
model
and
view
reports
related
to
Caboodle
configuration
and
operation.
Caboodle
BI
Developers
-
ANSwrite
Caboodle
reports
and
should
have
access
to
the
Caboodle
Dictionary
on
the
Console.
Dictionary
provides
table
descriptions,
data
lineage
for
tables
and
columns
and
foreign
key
information.
BI
Developers
should
be
familiar
with
Caboodles
dimensional
data
model
and
at
least
one
area
of
healthcare
reportings
such
as
revenue
or
clinical
reporting.
Caboodle
Administrators
-
ANShave
access
to
all
activities
on
the
Caboodle
Console.
Administrators
monitor
executions,
troubleshoot
work
queue
errors
and
establish
system
level
configurations.
Caboodle
ETL
Developers
-
ANScreate
custom
EPIC
and
n
on
Epic
content
for
extraction
into
the
data
warehouse,
document
their
work
in
the
dictionary
editor
and
test
their
work
using
the
ETL
tools
available
in
the
console.
Custom
development
notes
and
documentation
relevant
to
report
writers
will
be
visible
in
the
dictionary.
Why
use
Caboodle
-
ANSAccessibility,
Efficiency
and
fewer
tables
and
simpler
joins.
SSIS
package
-
ANSSQL
Server
Integration
packages
:
Data
is
extracted
from
source
systems
(Clarity)
transformed
in
the
staging
database
and
presented
for
users
in
the
reporting
database.
DMCs
-
ANSData
Model
Components Data
Model
Compenents
-
ANScollection
of
metadata
tables
that
support
the
ETL
process
and
reporting
views
stored
in
the
FullAccess
schema.
DMC
type
and
suffixes
-
ANSEach
DMC
gets
a
type
and
suffix.
Dim
for
dimensions,
Fact
for
facts,
Bridge
for
bridges,
Datamart
for
data
marts,
AttributeValueDim
for
EAV
tables,
X
for
custom
tables
Caboodle
Star
Schema
-
ANSwhere
one
central
fact
table
will
join
to
many
associated
lookup
or
dimension
tables.
Dimensional
Data
Model
-
ANSThis
structure
intentionally
makes
some
compromises
to
the
normalized
data
model
used
by
Clarity
in
order
to
facilitate
report
writing.
The
trade
off
is
that
it
requires
more
complicated
ETL
process
to
maintain.
Caboodle
consists
of
a
reporting
database
and
a
staging
database
-
ANS
dbo
-
ANSStaging
database:
import
tables
and
mapping
tables
live
here.
Used
by
administrators
for
moving
data
into
Caboodle.
Reporting
Database:
dbo
schema
stores
reporting
data
and
acts
as
the
data
source
for
SlicerDicer.
Caboodle
Dictionary
reflects
the
contents
of
the
dbo
schema
EPIC
-
ANSStaging
Database:
Epic
schema
on
the
staging
database
contains
the
_IdLookup
tables,
which
map
source
IDs
to
system-generated
Caboodle
primary
keys
in
the
reporting
database.
Reporting
Database:
Prior
to
Epic
2018
this
schema
stored
the
tables
used
by
the
SlicerDicer
patients
data
model.
FullAccess
-
ANSStaging
Database:
The
FullAccess
schema
does
not
exist
on
the
staging
database
Reporting
Database:
The
FullAccess
schema
houses
view
that
timplify
reporting.
FullAccess
should
be
your
default
schema
when
reporting.
DMC
-
ANSData
Model
Components
Business
Key
-
ANSIndentifier:
combination
of
columns
that
identify
records
Data
Lineage
-
ANSA
precise
technical
explanation
of
where
data
in
a
package
is
extracted
from
in
a
source
database.
Durable
Key
-
ANSAn
identifier
for
a
record
in
Caboodle
shared
across
rows
for
the
same
record.
Example
a
single
patient
record
might
have
multiple
rows
associated
with
it
in
Patient
Dim.
Each
row
has
the
same
durablekey
to
make
it
easy
to
find
all
rows
associated.
Foreign
Key
-
ANSthe
primary
key
for
a
row
in
a
different
able
in
Caboodle,
used
to
link
two
tables
together.
Foreign
keys
have
referential
integrity
-
ANSForeign
key
columns
never
contain
null
or
unmatched
values.
-1
foreign
key
value
-
ANSthe
foreign
key
is
unspecified
in
source
system
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 Qualitydocs. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
53068 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now