CDW110 EXAM WITH 100% C0RRECT QUESTIONS AND ANSWERS
CHAPTER 1-CLARITY flows into Caboodle data is extracted
from Clarity, transformed in the
... [Show More] staging database, and presented for users in the reporting database. This movement of data is realized via a set of SQL Server Integration Services (SSIS) packages.
CHAPTER 1-Caboodle Console - The Caboodle Console is a web application housed on the Caboodle server. It includes the following:
Dictionary Dictionary Editor Executions Work Queue Configuration
CHAPTER 1-Data Warehouse - In a data warehouse, multiple sources may load data pertaining to a single entity. This means that more than one package may populate a given row in a Caboodle table. As a result, there may be multiple business key values associated with a single entity in a Caboodle table.
CHAPTER 1-ETL - Extract, Transform, Load
CHAPTER 1-SSIS Package - The architecture of Caboodle includes a staging database and a reporting database. Data is extracted from source systems (like Clarity), transformed in the staging database, and presented for users in the reporting database. This movement of data is realized via a set of SQL Server Integration Services (SSIS) packages.
CHAPTER 1-Data Lineage - Generally, data lineage refers to the process of identifying the source of a specific piece of information. In Caboodle, data lineage is defined at the package level.
CHAPTER 1-Star Schema - The standard schema for a dimensional data model. The name refers to the image of a fact table surrounded by many linked dimension tables, which loosely resembles a star.
The Caboodle data model structure is based on a "star schema" ‐ where one central fact table will join to many associated lookup or dimension tables. This structure provides the foundation of the Caboodle data model.
CHAPTER 1-DMC - DATA MODEL COMPONENT
No table in Caboodle "stands alone." Each is considered part of a Data Model Component, which refers to the collection of metadata tables that support the ETL process and reporting views stored in the FullAccess schema.
Each DMC gets a type. Strict table naming conventions are followed in Caboodle, so that a table's suffix provides information about its structure and purpose.
These suffixes are:
• Dim for dimensions (e.g. PatientDim)
• Fact for facts (e.g. EncounterFact)
• Bridge for bridges (e.g. DiagnosisBridge)
• DataMart for data marts (e.g. HospitalReadmissionDataMart)
• AttributeValueDim for EAV tables (e.g. PatientAttributeValueDim)
• X for custom tables (e.g. CustomFactX)
CHAPTER 1-Staging Database - The Caboodle database into which records are loaded by SSIS packages and stored procedures.
CHAPTER 1-Reporting Database - The architecture of Caboodle includes a staging database and a reporting database. Data is extracted from source systems (like Clarity), transformed in the staging database, and presented for users in the reporting database. This movement of data is realized via a set of SQL Server Integration Services (SSIS) packages.
CHAPTER 1-Dbo Schema - STAGING DATABASE
Import tables and Mapping tables live here. This is
primarily used by administrators for moving data into Caboodle. [Show Less]